Đã hoàn thành

I need an excel expert

I have 450 beds in my building where I house students. Each bed is labeled A101a, A101b, A101c, and then next room is labeled A102a, A102b, A102c, and on. There are 30 rooms per floor with 3 beds per room for a potential of 90 people per floor. There are 5 floors in the building for a total of 450 beds. We work in two shifts, one is called days and one is called swings both with different sleep patterns. What I would like to be able to do is have two sheets in an excel document. The first sheet I would copy and paste 450 names into column A. I would copy and paste the giant list of assigned bed numbers into column B. I would copy and paste the assigned shift the students work into column 3. At this point you would see a name, the bed number, and the shift on the same line on this first sheet. I would then have the second sheet reference that data set and have a neat roster showing me in order 90 names in bed roster order pull the name and shift over on line with the specific bed number. So on the second sheet it would have A101A through A130C in cells in order and the document has a formula that pulls over the name that has the same bed number. It then tells me which beds are open by showing the empty space. Each of the 5 floors would then be printable on 5 - 8.5by11" sheets with 90 spaces on each sheet.

Just some additional notes about the document:

Column headers under the data tab should be as follows:

1. Unit

2. PLT

3. Rank

4. Name, Full

5. MOS

6. Component

7. Gender

8. SSN


10. DOB

11. Age

12. Barracks

13. Room

14. BASD

15. PEBD

16. ETS Date

17. Clearance Type

18. RFO - Has Clearance

19. Arrival Date

20. Class Start Date

21. Class #

22. Cadre Remarks

23. Shift Schedule

24. Grad Date

25. Class End Date

26. HO - Hold

27. RFO - Errors

28. UCMJ

29. Phase

30. Phone

31. Dental Category

32. Medical Category

33. Profile

34. Profile Start Date

35. Profile Days Left

36. Profile Expiration Date

37. Risk Level

38. Risk Notes

39. Married

40. Emergency Contact Name

41. Emergency Contact Number

42. Allergies

43. Cold Weather

44. Hot Weather

45. DX Days Remaining

46. DX Submitted

47. DX Complete

48. DX Notes

Each of these categories should have no restriction on the type of data input on it.

The bed roster should be pulling the data from column 13. Columns 4, 23, and 29 should also be visible next to the name on the bed check roster.

They will have “OPH” as the room number and we would like all those to be moved to the bottom.

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu

Xem nhiều hơn: need excel expert, need excel expert match columns, need excel expert create macro, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need excel data entry, i need excel expert, i need seo expert for my, i need seo expert, urgent i need an expert on grasshopper, www i need an expert to write my speech com, where can i hire excel expert, any company need excel expert from home, how do i find excel expert in sri lanka, i need an expert in facebook, i need an expert modeler, i need an expert to build a website, i need an expert to fix my wordpress website quotes

Về Bên Thuê:
( 1 Nhận xét ) Franklin, United States

ID dự án: #28346817

Được trao cho:


I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data A Thêm

$90 USD trong 1 ngày
(106 Đánh Giá)

6 freelancer chào giá trung bình$87 cho công việc này


hello, i did already similar work..i can start the work immediately once u awarding me .kindly chat with me we can discuss details and better understanding of your vision .i will provide u 100% correct work .thanks

$111 USD trong 2 ngày
(43 Nhận xét)

Hello, I'm a professional and skillful expert in Data works such as EXCEL,VBA,Gscripts, Googlesheets e,t,c ..My skills and services include: - Web scraping - Data processing - MySQL - Oracle -Financial Analysis -Advanc Thêm

$60 USD trong 2 ngày
(11 Nhận xét)

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project. Your satisfaction with th Thêm

$50 USD trong 2 ngày
(6 Nhận xét)

I will make it as soon as possible. I have a certification in Excel for Business Specialization. Also I can add Macros and Data Validation to make your entries much easier.

$70 USD trong 2 ngày
(0 Nhận xét)

Good day, I am an expert in data analysis and processing. I have 4 years experience in Data processing, analytics, visualisation and reporting. I have done a similar work as yours. I can help you with what you're askin Thêm

$140 USD trong 7 ngày
(0 Nhận xét)