tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 748676d1632280401-populate-dynamic-calendar-with-tasks-based-on-task-frequency-tasks-calendar-ans2
Sheet: Sheet1

 | Task1 | [NAME] | Task3 | Task4 | Task5 | Task6 | Task7 | Task8 | Task9 | Task10
2021-09-01 00:00:00
2021-09-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Example
2021-09-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Day one, week one should be the first Monday of the month.
2021-09-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarterly should be January, April, July and October.
2021-09-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Biannually should be March and September.
2021-09-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Some days will have multiple tasks. No tasks fall on a Sunday, Wednesday or Saturday.
2021-09-07 00:00:00
2021-09-08 00:00:00
2021-09-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task one | Daily | Weekly | Monthly
2021-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task two | Day 1 | Week 1 | Odd Months |  | First Monday
2021-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task three | Day 2 | Week 2 | Even Months |  | second Tuesday
2021-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task four | Day 4 | Week 3 | Quarterly |  | Thursday
2021-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task five | Day 5 | Week 4 | Biannualy |  | Friday
2021-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task six | Day 2 | Odd Weeks | Monthly |  | Tuesday
2021-09-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task seven | Day 4 | Even Weeks | Monthly |  | Thursday
2021-09-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task eight | Day 2 | Weekly | Monthly |  | Monday
2021-09-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task nine | Day 4 | Weekly | Odd Months |  | Thursday
2021-09-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task ten | Day 5 | Weekly | Even Months |  | Friday
2021-09-19 00:00:00
2021-09-20 00:00:00
2021-09-21 00:00:00
2021-09-22 00:00:00
2021-09-23 00:00:00
2021-09-24 00:00:00
2021-09-25 00:00:00
2021-09-26 00:00:00
2021-09-27 00:00:00
2021-09-28 00:00:00
2021-09-29 00:00:00
2021-09-30 00:00:00
2021-10-01 00:00:00
2021-10-02 00:00:00
2021-10-03 00:00:00
2021-10-04 00:00:00
2021-10-05 00:00:00
2021-10-06 00:00:00
2021-10-07 00:00:00
2021-10-08 00:00:00
2021-10-09 00:00:00
2021-10-10 00:00:00
2021-10-11 00:00:00
2021-10-12 00:00:00
2021-10-13 00:00:00
2021-10-14 00:00:00
2021-10-15 00:00:00
2021-10-16 00:00:00
2021-10-17 00:00:00
2021-10-18 00:00:00
2021-10-19 00:00:00
2021-10-20 00:00:00
2021-10-21 00:00:00
2021-10-22 00:00:00
2021-10-23 00:00:00
2021-10-24 00:00:00
2021-10-25 00:00:00
2021-10-26 00:00:00
2021-10-27 00:00:00
2021-10-28 00:00:00
2021-10-29 00:00:00
2021-10-30 00:00:00
2021-10-31 00:00:00
2021-11-01 00:00:00
2021-11-02 00:00:00
2021-11-03 00:00:00
2021-11-04 00:00:00
2021-11-05 00:00:00
2021-11-06 00:00:00
Spreadsheet: 47174d1246059656-find-and-retrieve-a-set-of-data-example-1-with-explanation
Sheet: Sheet1 (2)

This Data will be hidden
 |  | Jan Sales |  | Northeast | West |  |  |  |  | [NAME]()
Northeast | [NAME] | 100 |  | Southeast |  |  |  |  | SMALL()
Northeast | [NAME] | 100 |  | West |  |  |  | ONLY IF() STATEMENT
Northeast | [NAME] | 50
Northeast | Total
Southeast | [NAME] | 25
Southeast | [NAME] | 25
Southeast | [NAME] | 50
Southeast | [NAME] | 75
Southeast | [NAME] | 40
Southeast | Jaime | 20
Southeast | Total
West | Zac | 80
West | [NAME] | 80
West | [NAME] | 125
West | California Subtotal
West | [NAME] | 50
West | Dane | 45
West | Naomi | 25
West | [NAME] | 60
West | All Other Subtotal
West | Total
Spreadsheet: 864433d1711600536-array-formula-but-with-different-formula-inbetween-column-a-v-b-1-
Sheet: Budget

Description | 2023-04-30 00:00:00
Sales- Toy | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5400 | 5400 | 5400 | 5400
Sales-Food | 2000 | 2000 | 2000 | 2000 | 2000 | 2100 | 2100 | 2100 | 2100 | 2200 | 2200 | 2200
Sales-Furniture | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 4300 | 4300 | 4300 | 4300
Sales-Ad Hoc | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800
Spreadsheet: 542140d1507726420-overview-total-time-registration-with-names-codes-sample-time-registration-total
Sheet: TOTAL

Name | Project | Jan | Feb | Ma | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Piet
Piet
Piet
Piet
Jan
Jan
Jan
Jan
Kees
Kees
Kees
Hanna
Hanna
Hanna
Hanna
Fred
Fred
Fred
Fred
Fred
Spreadsheet: 846301d1697554996-how-to-sum-single-criteria-over-multiple-rows-demo-excel-forum
Sheet: Report Needed

 | Generic Name | Criteria | Part Data 1 (Should contain sum of Data 1, 2 and 4 from Sheet 1) | Part Data 2 (Should contain Data 3)
 | Orange | B | 15 | 7
 | [NAME] | D | 15 | 5
 | Pineapple | J | 9 | 6
 | Sugarcane | A | 11 | 8
 | Beans | C | 7 | 6
 | [NAME] | F | 13 | 3
 | Melon | E | 21 | 4
 | Mango | G | 18 | 2
 | Grape | H | 19 | 1
 | Lemon | I | 14 | 5
Spreadsheet: 122269d1316704902-excel-2007-vlookup-question-examplespreadsheet_revised
Sheet: DeficiencyAdj

Name | AcctNbr | DeficiencyAdj
Customer 1 | 123456 | 0
Customer 2 | 234567 | 0
Customer 2 | 234568 | 296.03
Customer 2 | 234569 | 0
Customer 3 | 987654 | 0
Customer 3 | 987653 | 0
Customer 3 | 987652 | 0
Customer 4 | 456789 | 0
Customer 6 | 222222 | 0
Customer 7 | 333333 | 94.41
Spreadsheet: 758786d1639065598-summing-data-with-criteria-q1-till-q2-till-q3-etc-summing-with-diferent-month
Sheet: Data

Order | Shuttle | Item | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 |  | Q1 | till Q2 | till Q3 | till Q4 | only March till April | full 1 year
1 | Jakarta | Things 1 | 5 | 4 | 10 | 2 | 12 | 6 | 3 | 8 | 4 | 1 | 2 | 5
2 | Bangkok | Things 1 | 6 | 6 | 12 | 3 | 23 | 7 | 3 | 9 | 5 | 2 | 3 | 6
3 | Hanoi | Things 1 | 7 | 4 | 5 | 41 | 4 | 8 | 3 | 7 | 6 | 3 | 4 | 7
4 | USA | Things 1 | 2 | 2 | 14 | 2 | 5 | 4 | 5 | 7 | 8 | 6 | 5 | 4
5 | China | Things 1 | 6 | 3 | 12 | 2 | 6 | 5 | 6 | 7 | 9 | 7 | 8 | 5
1 | Jakarta | Things 2 | 5 | 7 | 5 | 5 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4
2 | Bangkok | Things 2 | 6 | 8 | 6 | 5 | 10 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | Hanoi | Things 2 | 7 | 3 | 4 | 5 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4
4 | USA | Things 2 | 3 | 6 | 4 | 5 | 10 | 4 | 6 | 6 | 6 | 4 | 4 | 4
5 | China | Things 2 | 4 | 8 | 4 | 5 | 10 | 4 | 4 | 8 | 8 | 8 | 8 | 4
1 | Jakarta | Things 3 | 6 | 9 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
2 | Bangkok | Things 3 | 6 | 3 | 12 | 14 | 14 | 14 | 14 | 12 | 12 | 9 | 9 | 9
3 | Hanoi | Things 3 | 6 | 3 | 5 | 12 | 6 | 12 | 5 | 12 | 8 | 12 | 12 | 12
4 | USA | Things 3 | 8 | 4 | 5 | 12 | 6 | 12 | 5 | 12 | 8 | 6 | 6 | 6
5 | China | Things 3 | 9 | 5 | 5 | 12 | 12 | 12 | 12 | 12 | 14 | 14 | 12 | 12
Spreadsheet: 329210d1404230858-dates-in-gant-pivot-table-query
Sheet: Sheet1

 |  |  |  |  | Total crew
 |  |  |  |  | Department 1 INVOICED
 |  |  |  |  | Department 1 QUOTE
 |  |  |  |  | Department 1 RESERVATION
 |  |  |  |  | Department 2 INVOICED
 |  |  |  |  | Department 2 QUOTE
 |  |  |  |  | Department 2 RESERVATION
 |  |  |  |  | Department 3 INVOICED
 |  |  |  |  | Department 3 QUOTE
 |  |  |  |  | Department 3 RESERVATION
# | Order at | CREW ID | Department | start date | End date | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-02 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-09 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-08 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-07 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 | RESERVATION | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-04 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-05 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
Spreadsheet: 04667d2f-5380-4081-a44a-7e3f22517cc1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | FORM GC5 Revised 2/9/09 | Unnamed: 12
 |  |  | Kentucky Community and Technical College System |  |  |  |  |  |  |  | Effort Period:
 |  |  | After-the-Fact Certification of Time and Effort
Name: |  |  |  | Employee ID:
College: |  |  |  |  |  | Amounts Based on the PeopleSoft HR SYSTEM  -  Unless Designated as a JE Below
Fund | Dept | Prog | Class | Proj / Grt | Description | % Effort Charged Directly | $ Amount Charged  Directly | % Effort Cost Shared | $ Amount Cost Shared | % Total Effort | Journal Entry ID | Journal Entry Date
 |  |  |  |  |  | 0 | 0 | Semi-Annual Base Salary (Gross)
100% EFFORT CERTIFICATION
I certify that I have direct knowledge of 100 % of the effort of this employee.  I certify further, that to the best of my knowledge, the above effort reasonably reflects the actual
effort of this employee for the period covered by this report.  If it does not reasonably reflect the effort, provide documentation in the [NAME] or Comments section below.
Print Name:  ___________________________________________ |  |  |  |  |  | Signature:  ______________________________________
NOTE:  Only individuals having direct kowledge of all an employee's effort may certify effort.  Where feasible, employees should certify their own effort.
PRINCIPAL INVESTIGATOR / MANAGER OF SPONSORED PROJECT CERTIFICATION:
PI / Manager:  ___________________________________________ |  |  |  |  |  | Signature:  ______________________________________
Remarks or Comments:
Spreadsheet: 0e108d59-2bc7-4a83-a3f3-ce4620a7f1a7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LIND | Test | LIND | Linden, IgE | Linden, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
LIND | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LIND | Result | LIND | Linden, IgE | Linden, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11179-9
Spreadsheet: 845305d1696848172-vba-hotel-gantt-chart-with-merged-cells-and-details-of-booking-my-hotel
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Room No. | [NAME] | Depart Date | Duration | Price per day | Price per stay | No. Adults | No. Children | Cleaning? | Towels? | Tax Rate | Total Tax | Total Price | Deposit 1 | Payment Method | Deposit 2 | Payment Method | Total Deposit | Total to be Paid | PAID |  |  | SPILL Zone for available rooms
1 [NAME] | 1 | Direct | 12 | 2024-01-01 00:00:00 | 2024-01-04 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS |  |  |  |  | Yes |  |  |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1 [NAME] | 2 | Direct | 2 | 2024-01-03 00:00:00 | 2024-01-07 00:00:00 |  |  |  | 4 | 1 | 0 | 0 | 1 |  |  | 118 | BACS |  |  |  |  |  |  |  |  | 4 | 5 | 7 | 8 | 9 | 10 | 11
4 Karen Douglas | 1 | Direct | 6 | 2024-01-06 00:00:00 | 2024-01-10 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100 |  |  |  |  |  |  |  | 4 | 5 | 7 | 8 | 9 | 10 | 11 | 12
5 [NAME] | 1 | Booking | 3 | 2024-01-04 00:00:00 | 2024-01-11 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100 |  |  |  |  |  |  |  | 4 | 5 | 7 | 8 | 9 | 10 | 11 |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
6 [NAME] | 3 | Direct | 9 | 2024-01-17 00:00:00 | 2024-01-23 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 10 | 11 | 12
Spreadsheet: 91288d1291057230-excel-2007-formula-comparing-2-ranges-activity_summary_example
Sheet: EM Markets

Country
Algeria
Angola
Argentina
Azerbaijan
Bahrain
Benin
Brazil
Brunei
[NAME]
Burundi
Cameroon
Chad
Chile
China
Colombia
Congo
Czech Republic
Ecuador
Egypt
Gambia
Georgia
Ghana
Guinea
Hong Kong
Hungary
India
Indonesia
Iran
Iraq
Israel
Jordan
Kazakhstan
Kenya
Kuwait
Lebanon
Liberia
Libya
Malaysia
[NAME]
Mauritania
Mexico
Morocco
[NAME]
Nigeria
Oman
Pakistan
Peru
Philippines
Poland
Qatar
Romania
Russia
Rwanda
Saudi Arabia
Senegal
Sierra Leone
Singapore
Slovakia
Slovenia
South Africa
Sudan
Syria
Taiwan
Tanzania
Thailand
Togo
Tunisia
Turkey
Uganda
United Arab Emirates
Venezuela
Vietnam
Yemen
Spreadsheet: 874169d1720730656-calculating-ot-night-differential-and-night-differential-ot-sample
Sheet: Sheet1

 | DATE | HOUR DUTY |  | Hour [NAME] | Regular Time | Regular OT | Night Differential Reg | Night Differential OT | Total Night Differential
 |  | START | END
 | 2023-01-01 00:00:00 | 23:00:00 | 17:00:00
 |  | 05:00:00 | 13:45:00
 |  | 13:45:00 | 01:00:00
 |  | 05:00:00 | 13:40:00
 |  | 13:40:00 | 00:15:00
 |  | 05:00:00 | 13:44:00
 |  | 13:44:00 | 02:20:00
 |  | 05:55:00 | 13:45:00
 |  | 13:45:00 | 00:30:00
 |  | 19:00:00 | 03:30:00
 |  | 04:50:00 | 23:00:00
 |  | 04:45:00 | 13:55:00
 |  | 13:55:00 | 01:10:00
 |  | 04:46:00 | 13:15:00
 |  | 13:15:00 | 01:00:00
 |  | 04:44:00 | 15:10:00
 |  | 15:01:00 | 01:00:00
 |  | 05:50:00 | 14:00:00
 |  | 14:00:00 | 04:00:00
 |  | 04:30:00 | 14:00:00
 |  | 14:00:00 | 02:00:00
 |  | 18:00:00 | 05:00:00
 |  | 06:00:00 | 13:40:00
 |  | 13:40:00 | 01:34:00
Spreadsheet: 799816d1665324813-conditioned-formatting-with-formula-1390793
Sheet: Sheet1

 | 1 |  |  |  |  | D
 |  |  |  |  |  | A*B
 |  | 1 |  |  |  | A*C
 |  |  |  |  |  |  |  |  |  |  | rule 1: if D is blank, no formatting
70 |  |  | 76 |  |  | Rule 1 |  |  |  |  | rule 2: if D is less than A*B red colour fill
 |  |  |  |  |  | Rule 2 |  |  |  |  | rule 3: if D is greater/equal A*B and less/equal A*C green colour fill
 |  |  |  |  |  | Rule 3 |  |  |  |  | rule 4: if D is greater than A*C yellow colour fill
 |  |  |  |  |  | Rule 4
 |  |  |  |  |  |  |  |  |  |  | rules 1, 2 and 4 are fine. But I can't make rule 3 work which will not format the the cell
 |  |  |  |  |  |  |  |  |  |  | Test example:
 |  |  |  |  |  |  |  |  |  |  | A=70, B=1,1, C=1,3
 |  |  |  |  |  |  |  |  |  |  | D=blank no formatting
 |  |  |  |  |  |  |  |  |  |  | D=76 red colour fill
 |  |  |  |  |  |  |  |  |  |  | D=77 no formatting
 |  |  |  |  |  |  |  |  |  |  | D=91 no formatting
 |  |  |  |  |  |  |  |  |  |  | D=92 yellow colour fill
 |  |  |  |  |  |  |  |  |  |  | rule 1 =$D$10=" "
 |  |  |  |  |  |  |  |  |  |  | rule 2 =$[NAME])
 |  |  |  |  |  |  |  |  |  |  | rule 3 ="AND($D$10>=($A$10*$B$4),+$D$10<=($A$10*$C$6)"
 |  |  |  |  |  |  |  |  |  |  | rule 4 =$[NAME])
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -783122 | -801047 | -40000 | -40000
2 | -765413 | -746994 | -39998 | -40000
3 | -751586 | -748805 | -39999 | -40000
4 | -739284 | -742991 | -101
5 | -714787 | -734668
6 | -734353 | -750409 | -9877 | -10000
7 | -729199 | -722209 | -25859 | -25000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 145309
2001-08-07 00:00:00
CBS Dollars
 |  |  | 448987
Spreadsheet: 93348d1292947958-v-lookup-with-2-options-work-order-tracking-example
Sheet: Work Orders for FY11

ID | Wk Order # | Bldg # | Address | City | State | System | [NAME] | Commander | Inspector First Name | Inspector [NAME]
1 | 0000-00 | text | text | text |  | CCTV | text | text | text | text
172 | 100110-01 | CO0530 | 123 Main | LAKEWOOD | CO | Access Control |  | BEACH | ADRIAN | MARTINEZ
173 | 100110-02 | CO1977 | 789 State | DENVER | CO | Alarm | CO1010 | FEENEY | HARRY | DOLLARHIDE JR
174 | 100410-01 | ND0046 | 456 Broadway | FARGO | ND | Alarm | ND1014 | WILMORE | [NAME] | BEAUCHANE
175 | 100410-02 | CO0527 | 987 Ward | LAKEWOOD | CO | Alarm | CO1000 | BEACH | RANDOLPH | [NAME]
175 | 100410-02 | CO0527 | 987 Ward | LAKEWOOD | CO | Alarm | CO1000 | BEACH | RANDOLPH | [NAME]
176 | 100510-01 | CO0624 | 555 2nd | LAKEWOOD | CO | Alarm | CO1003 | BEACH | [NAME] | MARTINEZ
177 | 100610-01 | CO0530 | 123 Main | LAKEWOOD | CO | CCTV |  | BEACH | ADRIAN | MARTINEZ
178 | 100610-02 | UT0032 | 444 1st | SALT LAKE CITY | UT | Metal Detector |  | OSBORNE | ENRIQUE | JIMENEZ
Spreadsheet: 773817d1648054793-printing-multiple-payslips-from-pdf-payslip-updated
Sheet: 1005

 | Company Name
 | Address
 | Pay slip for the month of March 2022
 | Emp Code |  | Emp Name
 | Earnings |  | Deduction
 | Basic |  | NI
 | Medical |  | TAX
 | CONV Allowance
 | HRA
 | Total Addition |  | Total Deduction
 |  |  | Net Salary
 | Date
 | Signature of Employee |  | Director
Spreadsheet: 96256d1295650569-index-match-vlookup-or-offset-testcircuit
Sheet: Circuit Activity

Service Type | Circuit Locality | Billable Airline Miles | New Ulm 1442             % of Route | Western 1502      % of Route | New Ulm Invoice Total | Western Invoice Total | Grand         Total
DS1-NU | New Ulm to Owatonna | 64 | 0.06 | 0.19 | 554.7432 |  | 554.7432
DS1-NU | New Ulm to MEDFORD | 64 | 0.06 | 0.19 | 554.7432 |  | 554.7432
 | A DS1 (A2) that is going from New Ulm to Owatonna (B2), should be $554.74 for New Ulm, and $194.20 for Western.
 | I got the 554.74 to populate correctly, which is the value in the database tab, from E17.
 | The blue section in G2, should be the value from the database in F17.
 | I cannot find a way to make that populate.
 | [NAME] won't work, because the location of that column will depend on the service type (Col A) AND the circuit locality (Col B).
 | Index and Match won't work, like it does for the gold section, because the column headings on the database are not the same.
 | So, how can I get the cost of the circuit, that Western will bill, if it is a DS1 going from New Ulm to Owatonna?
 | I thought it would be easier than this.
Spreadsheet: 55438d1255547080-date-references-copy2-of-powertrain-predictor-working_oct2009
Sheet: Distribution (E)

Component Miles
Bus Model: |  |  | Engine Type
Units:
[NAME]
Low | 0
High | 100000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000000
Count
Valid Engine Types |  | 5
C12
DDEC
C13
S50
S60
[NAME] |  | 3
A
C
D
G
M
Spreadsheet: 5a2ef601-cbdd-41d7-ab8a-b2ef81625b2a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 14. Retail Turnover; Completely Enumerated (large) and Sample (small), By Industry Group
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total Sample Sector ;  Total (State) ;  Food retailing ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Food retailing ; |  |  | Original | A3350086L | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350186W | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Household goods retailing ; |  |  | Original | A3350102A | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350182L | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  [NAME], footwear and personal accessory retailing ; |  |  | Original | A3350190L | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Department stores ; |  |  | Original | A3350104F | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Other retailing ; |  |  | Original | A3350187X | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Other retailing ; |  |  | Original | A3350128X | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350074C | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Cafes, restaurants and takeaway food services ; |  |  | Original | A3350097V | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total Sample Sector ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350099X | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (State) ;  Total (Industry) ; |  |  | Original | A3350113J | 1994-04-01 00:00:00 | 2010-04-01 00:00:00 | 193 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2010