tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866324d1713277120-looking-for-a-way-convert-horizontal-data-into-vertical-clusters-based-on-unique-value-unit-mapping-file
Sheet: Results

Mapping | Floor | Area | Use
 | [NAME] (SQM) | 188 | Other
30056_tenant 1 | 3rd Basement (Parking Spots) | 1 | Retail
30056_tenant 2 | [NAME] (SQM) | 495.53 | Bank Branch
30056_tenant 2 | 1st Floor (SQM) | 495.53 | Bank Branch
30056_tenant 2 | 2nd Floor(SQM) | 495.53 | Bank Branch
30056_tenant 2 | 3rd Floor (SQM) | 495.53 | Office
30056_tenant 2 | 4th Floor (SQM) | 495.53 | Office
30056_tenant 2 | 5th Floor (SQM) | 495.53 | Office
30056_tenant 2 | 1st Basement (SQM) | 510.53 | Bank Branch
30056_tenant 2 | 1st Basement (Parking Spots) | 5 | Bank Branch
30056_tenant 2 | 2nd Basement (Parking Spots) | 10 | Bank Branch
30056_tenant 2 | Attic (SQM) | 90.75 | Office
30056_tenant 3 | [NAME] (SQM) | 207.8 | Retail
30056_tenant 3 | Mezzanine (SQM) | 107.4 | Retail
30056_tenant 3 | 1st Basement (SQM) | 207.8 | Retail
30056_tenant 3 | 1st Basement (Parking Spots) | 2 | Retail
0 | 3rd Basement (Parking Spots) | 0+EY10:FD10`` | Logistics
Spreadsheet: 3d441c86-fdbd-40ec-9474-35791049b8a5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259847 | 50329 | [NAME] | [NAME] | POL | 225 | 00:16:55 | 00:01:04 | 01:10:54 | 00:00:43 | 00:28:06 | 1 | [NAME]
259847 | 78351 | Maria | Weissenbacher | AUT | 226 | [NAME] | 00:01:23 | 01:13:05 | 00:00:48 | 00:26:22 | 2 | 01:57:59
259847 | 74909 | [NAME] | Hotchkiss | GBR | 224 | 00:16:47 | 00:01:16 | [NAME] | 00:01:20 | 00:30:24 | 3 | [NAME]
Spreadsheet: 35695d1233297215-excel-spreadsheet-design-for-calculating-occurrence-in-each-of-the-211876-combination-excelhelpcombincation
Sheet: Sheet1

Database |  |  |  |  |  |  |  |  |  | Combinations
A | B | C | D | E | F
1 | 7 | 27 | 36 | 40 | 48 |  |  |  |  | 1, 2, 3, 4
1 | 10 | 11 | 41 | 47 | 48 |  |  |  |  | 1, 2, 3, 5
7 | 14 | 21 | 43 | 44 | 47 |  |  |  |  | 1, 2, 3, 6
4 | 9 | 17 | 26 | 28 | 30 |  |  |  |  | 1, 2, 3, 7
8 | 10 | 28 | 35 | 37 | 47 |  |  |  |  | 1, 2, 3, 8
3 | 13 | 29 | 30 | 31 | 43 |  |  |  |  | 1, 2, 3, 9
5 | 6 | 27 | 33 | 36 | 37 |  |  |  |  | 1, 2, 3, 10
4 | 6 | 14 | 21 | 36 | 46 |  |  |  |  | 1, 2, 3, 11
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 12
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 13
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 14
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 15
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 16
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 17
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 18
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 19
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 20
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 21
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 22
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 23
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 24
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 25
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 26
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 27
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 28
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 29
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 30
 |  |  |  |  |  |  |  |  |  | 1, 2, 3, 31
Spreadsheet: 780892d1652858800-how-can-i-cycle-through-range-and-extract-text-from-rows-if-rows-contain-specific-text-daf-example-sheet-aligw
Sheet: Sheet1

Services List | Extracted Main Service | Extracted Secondary service list for each main service
Discovery Meeting
Discovery Meeting: Discovery Research | Location Scouting
Location Scouting: In Oradea | Creative Development
Creative Development: Creative Research | Production Management
Creative Development | Video Production
Creative Development: Roadmap Creation | Cloud Asset Management
Production Management: Location Scouting: In Oradea | Final Handout Message
Video Production: Camera Setup: With Collaborators
Cloud Asset Management: Copying
Final Handout Message
Spreadsheet: 213211d1360382336-timesheet-that-calcs-time-in-time-out-lunch-used-reg-hours-ot-hours-double-hours-timesheet-2013
Sheet: 021713

Non Exempt Employee Time Sheet
Employee Name |  | Social Security Number |  |  | Weekending:
Day | MM/DD | Time In | Time Out | Less Meal | Reg Hours | O/T Hours | D/T Hrs | Other Hrs | Comments
Monday | 2013-02-04 00:00:00 | 08:00:00 | 22:00:00 | 1 | 8 | 5.999999999999998
Tuesday | 2013-02-05 00:00:00
Wednesday | 2013-02-06 00:00:00
Thursday | 2013-02-07 00:00:00
Friday | 2013-02-08 00:00:00
Saturday | 2013-02-09 00:00:00
Sunday | 2013-02-10 00:00:00
Total Hours |  |  |  |  | 8 | 5.999999999999998 | 0 | 0
Monday | 2013-02-11 00:00:00
Tuesday | 2013-02-12 00:00:00
Wednesday | 2013-02-13 00:00:00
Thursday | 2013-02-14 00:00:00
Friday | 2013-02-15 00:00:00
Saturday | 2013-02-16 00:00:00
Sunday | 2013-02-17 00:00:00
Total Hours |  |  |  |  | 0 | 0 | 0 | 0
 |  | Grand Total Hours |  |  | 8 | 5.999999999999998 | 0 | 0
Employee Signature and Date |  |  | Supervisor Signature
Spreadsheet: 740533d1626367062-calculate-the-total-of-two-different-background-colour-figure-cells-in-same-column-sums-based-on-condition-thiajay-
Sheet: Sheet1

Agent | Alias | Profile ID | Contact Details | Item | Sold By | Cost | Paid | Received | Review Conditions | Review After | Review text | Review Submitted | Review Published | Refund Conditions | Refund Issued | Refund Received | Refund Email
 |  |  |  |  |  | 6.29 | 5.81
 |  |  |  |  |  | 9.98 | 9.39
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 5
 |  |  |  |  |  | 149.9
 |  |  |  |  |  | 26.99
 |  |  |  |  |  | 99.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 29.99
 |  |  |  |  |  | 52.99
 |  |  |  |  |  | 199.99
 |  |  |  |  |  | 10.99
 |  |  |  |  |  | 19.99
 |  |  |  |  |  | 21.9
 |  |  |  |  |  | 2.99
 |  |  |  |  |  | 7.99
 |  |  |  |  |  | 16.99 | 16.2
 |  |  |  |  |  |  | 70
 |  |  |  |  |  | 6.47
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: EIM New Deals

New Deals for | JANUARY |  |  |  |  |  |  |  | FEBRUARY |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | APRIL |  |  |  |  |  |  |  | MAY
 | Week Ending 4 |  | Week Ending 11 |  | Week Ending 18 |  | Week Ending 25 |  | Week Ending 1 |  | Week Ending 8 |  | Week Ending 16 |  | Week Ending 22 |  | Week Ending 28 |  | Week Ending 7 |  | Week Ending 14 |  | Week Ending 21 |  | Week Ending 28 |  | Week Ending 4 |  | Week Ending 11 |  | Week Ending 18 |  | Week Ending 25 |  | Week Ending 2 |  | Week Ending 9 |  | Week Ending 16 |  | Week Ending 23 |  | Week Ending 30
 | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
EIM
Lumber | 0 | 23 | 0 | 7 | 0 | 10 | 0 | 19 | 0 | 19 | 0 | 24 | 0 | 8 | 0 | 9 | 0 | 14 | 0 | 22 | 0 | 28 | 0 | 27 | 0 | 13 | 0 | 23 | 0 | 8 | 0 | 6 | 0 | 49 | 0 | 8 | 2 | 4 | 0 | 18 | 0 | 1 | 0 | 10 |  | for WE Apr 11 - up to limit on trading of lumber (wanted to go short, but didn't have room to trade)
Newsprint | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 10 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pulp (recycled paper) | 0 | 1 | 0 | 4 | 0 | 12 | 0 | 10 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 11 | 0 | 17 | 0 | 7 | 0 | 3 | 2 | 1 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | 10 | 0 | 8 | 0 | 0 | 0 | 6 | 0 | 5 | 0 | 7
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Physical
EIM
Lumber | 1 | 62 | 12 | 107 | 10 | 83 | 2 | 103 | 5 | 62 | 7 | 38 | 4 | 26 | 2 | 30 | 5 | 50 | 7 | 55 | 7 | 45 | 5 | 62 | 9 | 101 | 3 | 119 | 3 | 101 | 1 | 107 | 4 | 119 | 4 | 119 | 6 | 90 | 6 | 97 | 5 | 61 | 1 | 79
Newsprint | 0 | 3 | 0 | 15 | 1 | 6 | 0 | 22 | 0 | 4 | 0 | 2 | 0 | 18 | 0 | 17 | 0 | 18 | 0 | 20 | 2 | 43 | 1 | 24 | 5 | 9 | 1 | 23 | 5 | 37 | 3 | 44 | 1 | 23 | 0 | 17 | 3 | 22 | 1 | 52 | 0 | 77 | 1 | 18
Pulp (recycled paper) | 4 | 1 | 3 | 10 | 0 | 12 | 0 | 9 | 2 | 23 | 4 | 13 | 3 | 12 | 3 | 18 | 5 | 41 | 4 | 11 | 9 | 10 | 2 | 35 | 0 | 29 | 3 | 24 | 2 | 28 | 2 | 22 | 2 | 5 | 0 | 19 | 3 | 22 | 4 | 13 | 2 | 19 | 1 | 14
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 7 | 0 | 1 | 5 | 0 | 0 | 4 | 0 | 8 | 0 | 6 | 0 | 7 | 0 | 17 | 0 | 17 | 0 | 0
Spreadsheet: 329042d1404177046-vlookup-between-two-sheets-including-entire-row-fmsonline-wip
Sheet: Mnth Temp

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ti
 |  | Reading and Sales
 |  | Date |  | Unleaded |  |  |  | Premium |  |  |  |  | Diesel
 |  |  |  | Reading* | Gallons | Sales |  | Reading* | Gallons | Plus Sales | [NAME]. Sales |  | Reading* | Gallons | Sales |  | Tank | Reading |  | Delivery |  | Sales | Over/Short | Cummlative O/S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reading* | Gallons | Gross Delivery | Net Delivery
 |  | 2004-07-01 00:00:00
 |  | 2004-07-02 00:00:00
 |  | 2004-07-03 00:00:00
 |  | 2004-07-04 00:00:00
 |  | 2004-07-05 00:00:00
 |  | 2004-07-06 00:00:00
 |  | 2004-07-07 00:00:00
 |  | 2004-07-08 00:00:00
 |  | 2004-07-09 00:00:00
 |  | 2004-07-10 00:00:00
 |  | 2004-07-11 00:00:00
 |  | 2004-07-12 00:00:00
 |  | 2004-07-13 00:00:00
 |  | 2004-07-14 00:00:00
 |  | 2004-07-15 00:00:00
 |  | 2004-07-16 00:00:00
 |  | 2004-07-17 00:00:00
 |  | 2004-07-18 00:00:00
 |  | 2004-07-19 00:00:00
 |  | 2004-07-20 00:00:00
 |  | 2004-07-21 00:00:00
 |  | 2004-07-22 00:00:00
 |  | 2004-07-23 00:00:00
 |  | 2004-07-24 00:00:00
 |  | 2004-07-25 00:00:00
 |  | 2004-07-26 00:00:00
 |  | 2004-07-27 00:00:00
 |  | 2004-07-28 00:00:00
 |  | 2004-07-29 00:00:00
 |  | 2004-07-30 00:00:00
 |  | 2004-07-31 00:00:00
Spreadsheet: 745057d1629720958-counting-time-overlaps-sample
Sheet: Sheet1

Name | Entry | Exit
[NAME] | 12:30:00 | 14:00:00 |  | [NAME]
[NAME] | 13:00:00 | 13:30:00 |  | (Expected Result: 4)
Eve | 13:00:00 | 13:45:00
[NAME] | 13:15:00 | 13:30:00
[NAME] | 14:15:00 | 15:00:00
[NAME] | 14:30:00 | 14:45:00
Spreadsheet: 805220d1668595309-locking-formulas-for-changing-cells-sample
Sheet: Sheet1

Bestilling |  |  |  |  |  |  | Er lagt til afsendelse
Bestillings dato | Model | Farve | Del | Antal | sagsnummer |  | Afsendelsesdato | Model | Farve | Del | Antal | sagsnummer
 | iphone 1 | Grøn | Bagcover | 1 | 123456 |  |  | iphone X | Black | Battery | 2
 | iphone 1 | Grøn | Bagcover | 1 | 123456
Spreadsheet: 6d17c26e-8084-4532-bedf-4220e1cbfb7c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | OWS-7 Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
Total Labor |  |  |  |  | 9500 | 9500
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
OWS-6 Kickoff | 4 days | flight, lodging, per diem | 3000 | 1 | 3000
OWS-6 Demo | 2 days | flight, lodging, per diem | 3000 | 2 | 6000
Total Travel |  |  |  |  | 9000 | 18500
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 83500
Grand Total Cost Share Funds Request |  |  |  |  | 83500
Spreadsheet: 02b040d2-3f6a-4292-a1b5-f91836c1411b
Sheet: Sheet1

Unnamed: 0 | THE UNIVERSITY OF TENNESSEE | Unnamed: 2 | Unnamed: 3 | INITITAL___________ | Attachment C
 | COUNT OF PETTY CASH |  |  | DATE_____________
 | Date______________________
 | DEPARTMENT
 | IMPREST AMOUNT OF FUND
 |  |  |  |  | Total
Balance in bank per check no. |  | Dated: |  |  | $__________
Name of Bank
Address of Bank
Authorized Signature
Cash on hand:   (Currency) | $
(Change) | $
**(Checks) | $
**List checks in detail below and explain nature of item.
Check Date | Drawn On | Items Covered |  | Amount
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $ | $__________
Vouchers in Transit (To Treasurer's Office for Reimbursement)
Transmittal Date |  |  |  | Amount
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $ | $__________
 |  |  |  |  | Pg 1 of 3
Paid Invoices or T-4's on Hand
Date | Payee |  |  | Amount
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $
 |  |  |  |  | $__________
Funds Advanced to Others
Date | Name | Purpose |  | Amount
 |  |  |  | $
 |  |  |  | $
 |  |  |  | $
 |  |  |  |  | $__________
Other Cash Items (Describe)
 |  |  |  |  | $__________
Receipt:
The above petty cash fund was counted in my presence by |  |  |  | Total | $__________
 | on (date)__________ as was returned to me intact. |  |  | Over (Short) | $__________
 |  |  |  | Total Fund | $__________
 | [NAME]
 | Date
** Start with page 3 and work your way to page 1 |  |  |  |  | Pg 2 of 3
 |  |  |  |  | Pg 3 of 3
Spreadsheet: 793939d1661800428-multiple-closest-matches-with-multiple-criteria-book1-tool_fairy-
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4
Staff 5
Staff 6
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 10:15:00 | 10:16:00 | 1 | 11 | 12:15:00 | 12:18:00 | 3 | 30 | 14:15:00 | 14:47:00 | 32 | 8
Staff 2 | 11:45:00 | 11:50:00 | 5 | 10 | 14:15:00 | 14:19:00 | 4 | 30 | 15:45:00 | 15:49:00 | 4 | 10
Staff 3 | 10:00:00 | - | - | - | 11:45:00 | 11:47:00 | 2 | 30 | 13:45:00 | 14:02:00 | 17 | 9
Staff 4 | 10:15:00 | 10:16:00 | 1 | 10 | 12:15:00 | 12:23:00 | 8 | 30 | 13:45:00 | 13:46:00 | 1 | 10
Staff 5 | 10:00:00 | 10:02:00 | 2 | 8.999999999999968 | 11:45:00 | 11:47:00 | 2 | 30 | 13:45:00 | - | - | -
Staff 6 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 587503d1535046701-rank-subgroups-without-duplicates-rank-exemplar
Sheet: Sheet1

Participant Number | Year | Rank
1 | 1994 | 1
1 | 1994 | 1
1 | 1995 | 2
1 | 1996 | 3
1 | 1997 | 4
1 | 1997 | 4
1 | 1997 | 4
2 | 1998 | 1
2 | 1998 | 1
2 | 1998 | 1
2 | 1998 | 1
2 | 1999 | 2
2 | 1999 | 2
2 | 2000 | 3
2 | 2000 | 3
3 | 1992 | 1
3 | 1993 | 2
3 | 1993 | 2
3 | 1993 | 2
3 | 1993 | 2
3 | 1994 | 3
3 | 1995 | 4
3 | 1995 | 4
Spreadsheet: 148900d1333609201-how-to-change-the-formulas-in-multiple-sheets-test-1
Sheet: Bill 2

 | EXHIBIT C
 | SECTION 4
 | SCHEDULE  A
 | MONTHLY STATEMENT No. 53 FOR THE PERIOD OF FEBRUARY AND MARCH 2012
 | SECTION | CODE | [NAME]. 2: FUEL FARM (C5110, C5150, C5160) |  |  | UNIT RATES |  |  | TOTAL |  |  |  | QUANTITY |  |  | AMOUNT
 |  | ITEM
 | NO. | NO. |  | Q'TY | UNIT
 |  |  | [NAME] |  |  | MATERIAL | INSTALLATION | TOTAL | MATERIAL | INSTALLATION | TOTAL |  | PREVIOUS | CURRENT | TO DATE | PREVIOUS | CURRENT | TO DATE
 |  |  |  |  |  | QAR | QAR | QAR | QAR | QAR | QAR
 |  |  |  | a |  | b | c | d=b+c | e=a*b | f=a*c | g=e+f
2
2 | 00000 |  | DESIGN SERVICES
2
2 | 00000 | 001 | Civil | 1 | LS | 0 | 1734495.989157864 | 1734495.989157864 | 0 | 1734495.989157864 | 1734495.989157864 |  | 1 |  | 1 | 1734495.99 | -0.0008421363309025764 | 1734495.989157864
2 | 00000 | 002 | Structural | 1 | LS | 0 | 1057960.349784915 | 1057960.349784915 | 0 | 1057960.349784915 | 1057960.349784915 |  | 1 |  | 1 | 1057960.35 | -0.0002150852233171463 | 1057960.349784915
2 | 00000 | 003 | Architectural | 1 | LS | 0 | 854917.4543716485 | 854917.4543716485 | 0 | 854917.4543716485 | 854917.4543716485 |  | 1 |  | 1 | 854917.45 | 0.004371648537926376 | 854917.4543716485
2 | 00000 | 004 | Mechnical | 1 | LS | 0 | 1706546.764688022 | 1706546.764688022 | 0 | 1706546.764688022 | 1706546.764688022 |  | 1 |  | 1 | 1706546.76 | 0.004688021494075656 | 1706546.764688022
2 | 00000 | 005 | Electrical | 1 | LS | 0 | 1079333.286144206 | 1079333.286144206 | 0 | 1079333.286144206 | 1079333.286144206 |  | 1 |  | 1 | 1079333.29 | -0.003855793736875057 | 1079333.286144206
2 | 00000 | 006 | Interior Design | 1 | LS | 0 | 406085.790826533 | 406085.790826533 | 0 | 406085.790826533 | 406085.790826533 |  | 1 |  | 1 | 406085.79 | 0.0008265330689027905 | 406085.790826533
2 | 00000 | 007 | Life Safety | 1 | LS | 0 | 438145.1953654698 | 438145.1953654698 | 0 | 438145.1953654698 | 438145.1953654698 |  | 1 |  | 1 | 438145.2 | -0.004634530167095363 | 438145.1953654698
2 | 00000 | 008 | Special Systems & Equipment | 1 | LS | 0 | 1709834.908743297 | 1709834.908743297 | 0 | 1709834.908743297 | 1709834.908743297 |  | 1 |  | 1 | 1709834.91 | -0.001256702933460474 | 1709834.908743297
2 | 00000 | 009 | Final Handover Documentation in accordance with Exhibit B, Special Conditions, clause SC-6.7 | 1 | LS | 0 | 25000 | 25000 | 0 | 25000 | 25000 |  | 0 |  | 0 | 0 | 0 | 0
2 | 00000 | 010 | Design Support during Construction Phase | 1 | LS | 0 | 287767.3061044585 | 287767.3061044585 | 0 | 287767.3061044585 | 287767.3061044585 |  | 1 |  | 1 | 287767.31 | -0.003895541478414088 | 287767.3061044585
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
2 |  |  | SUB-TOTAL OF SECTION 00000 |  |  |  |  |  | 0 | 9300087.045186413 | 9300087.045186413 |  |  |  |  | 9275087.05 | -0.004813587293028831 | 9275087.045186413
Spreadsheet: 675262d1588223650-problem-using-index-match-with-merged-cells-example1686
Sheet: Sheet2

YTD March 2020 Actual to Budget Comparison
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
***I WANT THE NUMBERS TO TOTAL SO IT SHOULD LOOK LIKE THIS:
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
Spreadsheet: 107553d1304687602-how-to-get-a-number-split-into-separate-cells-while-being-changed-into-words-numbers999999-00-v2
Sheet: Sheet1

 |  | 100000 | 10000 | 1000 | 100 | 10 | 1 | 0.00
999999.99 |  | nine | nine | nine | nine | nine | nine | nine-nine
123.12 |  |  |  |  | one | two | three | one-two
24576.01 |  |  | two | four | five | seven | six | zero-one
123 |  |  |  |  | one | two | three | zero-zero
99999.99 |  |  | nine | nine | nine | nine | nine | nine-nine
123.12 |  |  |  |  | one | two | three | one-two
24576.01 |  |  | two | four | five | seven | six | zero-one
123 |  |  |  |  | one | two | three | zero-zero
1 |  |  |  |  |  |  | one | zero-zero
12 |  |  |  |  |  | one | two | zero-zero
123 |  |  |  |  | one | two | three | zero-zero
1234 |  |  |  | one | two | three | four | zero-zero
12345 |  |  | one | two | three | four | five | zero-zero
123456 |  | one | two | three | four | five | six | zero-zero
123456 |  | one | two | three | four | five | six | zero-zero
1.15 |  |  |  |  |  |  | one | one-five
12.15 |  |  |  |  |  | one | two | one-five
123.15 |  |  |  |  | one | two | three | one-five
1234.15 |  |  |  | one | two | three | four | one-five
12345.15 |  |  | one | two | three | four | five | one-five
123456.15 |  | one | two | three | four | five | six | one-five
Spreadsheet: 739190d1625572669-index-match-returns-n-a-error-test
Sheet: JANUARY

 |  |  |  |  |  |  | ^^ expand/collapse monthly summary |  |  |  |  |  |  |  |  |  | ^^ arrow in column N for Upload Data |  |  |  |  |  |  |  |  |  |  |  | ^^ arrow in column W for more info
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  | unfilled
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total vacs
 |  |  |  |  |  |  | January Vacancies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fully filled
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | emp formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | emp
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Adverts | Vacancy ID | Bid Employer ID | KS Ref | Uploaded on | Start date | End date | Closed / Live | Closing date | Employer name | Job Title | Sector | [NAME] [Y] or Child Employer [N] or Employer Bid [NA] | Work Type | Postcode | JCP Area | JCP Group | [NAME] | Jobcentre | Status | number of days remaining before closure | vacancies [7+ days old] with no referrals | vacancies uploaded | referrals | starts | starts ended early
 |  |  |  |  |  |  | Status | Advert Id | BID Employer ID | Bid ID | Created At | Live Date | No. Of Vacancies | Unfilled Ending within 7 Days | No. Of Referrals | No. Of Starts | Starts Ended Early | Completed | Closing Date | Employer Name | Job Title | Sector | Work Type | Postcode | JCP Area | JCP Group | [NAME] | [NAME] | [NAME] | Geography | Status | Is Gateway | completed |  |  |  | [NAME] | Ealing | Fulham | Harlesden | [NAME] | [NAME] | Hounslow | Kingston | [NAME] | [NAME] | Uxbridge | Wandsworth | Wembley
 |  |  |  |  |  |  | Filled | 206272
 |  |  |  |  |  |  | Filled | 207226
 |  |  |  |  |  |  | Filled | 207322
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: ZOA

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty.
ZOA ZS BERRY 12/12Z CN | 09916 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Hotel dop offs to include in forecast
ZOA ZS CHRY LI 12/12Z CN | 10534
ZOA ZS PINE CO 12/12Z CN | 09917
ZOA ZS STRWB W 12/12Z CN | 10533
ZOA ZS TROP PN 12/12Z CN | 09915
ZOA ZS W ORANG 12/12Z CN | 09918
ZOA ZS WHT PCH 12/12Z CN | 09914
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
ZOA ZS BERRY 12/12Z CN | 09916
ZOA ZS CHRY LI 12/12Z CN | 10534
ZOA ZS PINE CO 12/12Z CN | 09917
ZOA ZS STRWB W 12/12Z CN | 10533
ZOA ZS TROP PN 12/12Z CN | 09915
ZOA ZS W ORANG 12/12Z CN | 09918
ZOA ZS WHT PCH 12/12Z CN | 09914
Spreadsheet: 681172d1591375632-sumifs-sumproduct-for-a-list-of-criteria-test-workbook
Sheet: Sheet2

67299.71 | Sum of the cost based off if the unit has a lease amount greater than zero
13459.92 | Average of the cost based off if the unit has a lease amount greater than zero
Unit | Cost |  |  | Unit | Lease Amt
0122 | 10277.5 |  |  | 814 | 2000
0634 | 11565.5 |  |  | 934 | 0
0814 | 15277.54 |  |  | 1022 | 1000
0934 | 10600.78 |  |  | 1213 | 0
1222 | 10275 |  |  | 1331 | 1400
1331 | 10615.06 |  |  | 1433 | 1200
1433 | 10590.59 |  |  | 2021 | 0
1731 | 11015 |  |  | 2121 | 0
2021 | 11118.19 |  |  | 2314 | 0
2314 | 19158.82 |  |  | 2413 | 0
2322 | 10693.58 |  |  | 2613 | 2000
2323 | 11156.65 |  |  | 2724 | 0
2331 | 10314.15 |  |  | 2832 | 0
2613 | 19698.33
3112 | 12740.56
3122 | 11815.43
3123 | 11313.54
3124 | 10398.89
3134 | 10651.39
Spreadsheet: 90131d1289906480-rank-repeat-value-not-to-ignore-the-next-rank
Sheet: Sheet1

Present |  |  | Required Table
Mark | Rank |  | Mark | Rank
1 |  |  | 1 | 9
2 |  |  | 2 | 8
2 |  |  | 2 | 8
3 |  |  | 3 | 7
4 |  |  | 4 | 6
4 |  |  | 4 | 6
5 |  |  | 5 | 5
6 |  |  | 6 | 4
7 |  |  | 7 | 3
8 |  |  | 8 | 2
8 |  |  | 8 | 2
9 |  |  | 9 | 1