tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 691311d1597644283-count-total-sales-under-multiple-conditions-formula-or-code-help0817-3
Sheet: Sheet2

Product Name | Country Origin | January | February | March | April | May | June | July | August | September | October | November | December |  |  | Conditions
Red apple | United States | 3679 | 3680 | 3681 | 3682 | 3683 | 3684 | 3685 |  |  |  |  |  |  |  | Product
Big banana | United States | 3680 | 3681 | 3682 | 3683 | 3684 | 3685 | 3686 |  |  |  |  |  |  | 1 | [NAME]Including small & Big)
orange | United States | 3681 | 3682 | 3683 | 3684 | 3685 | 3686 | 3687 |  |  |  |  |  |  | 2 | Apple (including Red & Green) |  |  | [NAME] (1+2+3+4+5+67+8+9)
chestnut | United States | 3682 | 3683 | 3684 | 3685 | 3686 | 3687 | 3688 |  |  |  |  |  |  |  |  |  |  | 88590
cucumber | United States | 3683 | 3684 | 3685 | 3686 | 3687 | 3688 | 3689 |  |  |  |  |  |  |  | Country Origin
cabbage | United States | 3684 | 3685 | 3686 | 3687 | 3688 | 3689 | 3690 |  |  |  |  |  |  | 3 | Australia
Durian | United States | 3685 | 3686 | 3687 | 3688 | 3689 | 3690 | 3691 |  |  |  |  |  |  | 4 | United States
Green apple | Australia | 3686 | 3687 | 3688 | 3689 | 3690 | 3691 | 3692 |  |  |  |  |  |  | 5 | Chile
Small banana | Australia | 3687 | 3688 | 3689 | 3690 | 3691 | 3692 | 3693 |  |  |  |  |  |  | 6 | Japan
orange | Australia | 3688 | 3689 | 3690 | 3691 | 3692 | 3693 | 3694
chestnut | Australia | 3689 | 3690 | 3691 | 3692 | 3693 | 3694 | 3695 |  |  |  |  |  |  |  | Month
cucumber | Australia | 3690 | 3691 | 3692 | 3693 | 3694 | 3695 | 3696 |  |  |  |  |  |  | 7 | February
cabbage | Australia | 3691 | 3692 | 3693 | 3694 | 3695 | 3696 | 3697 |  |  |  |  |  |  | 8 | April
Durian | Australia | 3692 | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 |  |  |  |  |  |  | 9 | June
Green apple | Chile | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 | 3699
Small banana | Chile | 3694 | 3695 | 3696 | 3697 | 3698 | 3699 | 3700
orange | Chile | 3695 | 3696 | 3697 | 3698 | 3699 | 3700 | 3701
chestnut | Chile | 3696 | 3697 | 3698 | 3699 | 3700 | 3701 | 3702
cucumber | Chile | 3697 | 3698 | 3699 | 3700 | 3701 | 3702 | 3703
cabbage | Chile | 3698 | 3699 | 3700 | 3701 | 3702 | 3703 | 3704
Durian | Chile | 3699 | 3700 | 3701 | 3702 | 3703 | 3704 | 3705
Apple | Japan | 3693 | 3694 | 3695 | 3696 | 3697 | 3698 | 3699
banana | Japan | 3694 | 3695 | 3696 | 3697 | 3698 | 3699 | 3700
orange | Japan | 3695 | 3696 | 3697 | 3698 | 3699 | 3700 | 3701
chestnut | Japan | 3696 | 3697 | 3698 | 3699 | 3700 | 3701 | 3702
cucumber | Japan | 3697 | 3698 | 3699 | 3700 | 3701 | 3702 | 3703
cabbage | Japan | 3698 | 3699 | 3700 | 3701 | 3702 | 3703 | 3704
Durian | Japan | 3699 | 3700 | 3701 | 3702 | 3703 | 3704 | 3705
REMARKS　：　The product category does not represent the original country, it is just an example
Spreadsheet: e5a8d7e6-d66e-410c-9deb-2399668856c2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7102 | 72731 | Ricardo | Marin [NAME] | ESP | 69 | 00:19:57 | 00:03:44 | 01:48:57 | 00:01:30 | [NAME] | 1 | 03:16:13
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 10a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | 0 | 14464730 | 14464730
Cross-Currency Fixed-Fixed | 0 | 421123 | 421123
Cross-Currency Fixed-Float | 0 | 1315016 | 1315016
TOTAL | - | 16200869 | 16200869
Spreadsheet: 129861d1321941729-data-validation-test1
Sheet: Sheet1

20 | 2400 |  |  |  |  |  |  |  |  |  |  |  | 6 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1100
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1300
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1400
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 1700
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 1800
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 1900
 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 2100
 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 2200
 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 2300
 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2400
 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2500
 |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 2600
Spreadsheet: 721040d1614439987-excel-index-match-retrieving-multiple-columns-of-data-examplefilter
Sheet: Total

Investor | Company | Year | Amount
[NAME] | nike | 2020 | 100
ron | adidas | 2018 | 200
grant | nike | 2019 | 100
drew | reebox | 2019 | 300
billy | adidas | 2018 | 100
will | reebok | 2020 | 400
[NAME] | nike | 2020 | 100
[NAME] | adidas | 2019 | 200
[NAME] | nike | 2020 | 300
al | adidas | 2018 | 400
[NAME] | reebok | 2019 | 600
justin | nike | 2019 | 300
[NAME] | nike | 2020 | 200
[NAME] | reebok | 2019 | 500
ryan | nike | 2018 | 400
nathan | adidas | 2019 | 100
[NAME] | adidas | 2019 | 100
[NAME] | nike | 2018 | 300
Spreadsheet: 733289d1621492529-using-a-text-value-as-range-by-indirect-function-in-a-vlookup-to-get-a-corresponding-value-label-to-used-as-range-by-indirect
Sheet: Label Used as Range by Indirect

 | Executive_Rng |  |  |  |  | Team_Leader_Rng |  |  |  |  |  |  |  | 2 | 3 | 4
Sr.No | Employee No | Name as in Official Records | Total |  | Sr.No | Employee No | Name as in Official Records | Total |  | Min | [NAME] | Range To be Used |  | Employee No | Name as in Official Records | Total
1 | 1000 | Executive 1 | 68.39658 |  | 5 | 2000 | Team Leader 1 | 4516 |  |  |  | Executive_Rng |  |  |  |  |  | In this case, I am writing Executive_Rng and then using in VLOOKUP
2 | 1001 | Executive 2 | 23.938803 |  | 6 | 2001 | Team Leader 2 | 1649 |  |  |  | Team_Leader_Rng
 | 1002 | Executive 3 | 60.03710629999999 |  | 7 | 2002 | Team Leader 3 | 2957 |  |  |  |  |  |  |  |  |  | Instead if I could use it this way such as
 | 1003 | Executive 4 | 17.6691165 |  |  | 2003 | Team Leader 4 | 1327 |  |  |  |  |  |  |  |  |  | =VLOOKUP(1,K:M,3,1)
 | No |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  | as the above VLOOKUP wil give me the [NAME] - Executive_Rng for any value between 1 and 4 and Team_Leader_Rng for values between 5 and 8.
 |  |  |  |  |  | As the Executive Rang is also made usig formulas
 |  |  |  |  |  | its giving problems |  |  |  |  |  |  |  | Desired Output using Dynamic Executive_Rng and Team_Leader_Rng
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee No | Name as in Official Records | Total
 |  |  |  |  |  | If I keep it simple and hard-coded then I get the result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In this case only Executive_Rng is Dynamic so its not giving #REF Error.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team_Leader_Rng is a hard-coded range so its correct.
Spreadsheet: 197799d1354562228-numbers-are-disappearing-when-linking-to-another-worksheet-workbook130
Sheet: REPARTEE A

3 | 10
5 | 1.722222222222222
7 | 3.333333333333333
11 | 2.055555555555556
13 | 2.916666666666667
19 | 3.333333333333333
21 | 2.5
23 | 3.75
25 | 3.75
27 | 5
29 | 2.055555555555556
31 | 2.222222222222222
35 | 10
37 | 10
39
45 | 3.333333333333333
49 | 2.5
51 | 2.5
55 | 10
59 | 1.944444444444445
63 | 3.75
65 | 5
69 | 10
71 | 3.333333333333333
73 | 3.333333333333333
Spreadsheet: 52fe7451-29d0-49b9-8626-d2fb4d7123e0
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
CEA | Test | CEA | Carcinoembryonic Antigen (CEA), Serum | Carcinoembryonic Ag (CEA), S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.6 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Nonsmokers: < or =3.0 ng/mL Some smokers may have elevated CEA, usually <5.0 ng/mL. Serum markers are not specific for malignancy, and values may vary by method. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 82378 |  |  |  |  | Rochester
CEA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CEA | Result | CEA | Carcinoembryonic Ag (CEA), S | Carcinoembryonic Ag (CEA), S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2039-6
Spreadsheet: 883929d1732721086-look-for-name-get-value-from-another-cell-if-blank-go-to-next-instance-of-that-name-bottom-up-search
Sheet: Sheet1

Session | Name | Starting Level | Current Level
1 | [NAME] | 1
1 | [NAME] | 4
1 | [NAME] | 3 |  |  |  |  | What I am looking for:
2 | [NAME] |  | 3
2 | [NAME] |  | 4 |  |  |  | Name | Starting Level | Current Level
2 | [NAME] |  | 4 |  |  |  | [NAME]
3 | [NAME] |  | 5 |  |  |  | [NAME]
3 | [NAME] |  |  |  |  |  | [NAME]
3 | [NAME]
 |  |  |  |  |  |  |  | Starting Level | Current Level
 |  |  |  |  |  |  | [NAME] | 1 | 5
 |  |  |  |  |  |  | [NAME] | 4 | 4
 |  |  |  |  |  |  | [NAME] | 3 | 4
Spreadsheet: 763164d1642013876-start-array-based-on-matching-criteria-example
Sheet: Mon ($)

 | SKU Number | Region | Releast date | Aug 22 | Sep 22 | Oct 22 | Nov 22 | Dec 22 | Jan 23 | Feb 23 | Mar 23 | Apr 23 | May 23 | Jun 23 | Jul 23 | Aug 23 | Sep 23 | Oct 23 | Nov 23 | Dec 23
 | 120 | 1 | Dec 22
 | 121 | 1 | Sep 22
 | 122 | 1 | Dec 22
 | 123 | 1
 | 124 | 1
 | 125 | 1
 | 126 | 1
 | 120 | 2
 | 121 | 2
 | 122 | 2
 | 123 | 2
 | 124 | 2
 | 125 | 2
 | 126 | 2
 | 120 | 3
 | 121 | 3
 | 122 | 4
 | 123 | 5
 | 124 | 6
 | 125 | 7
 | 126 | 8
Spreadsheet: 84751d1284749067-if-function-buyer-worksheet-2
Sheet: Follow-Ups

[NAME]
# | Call Date | Appt. Date | Street | City | Zip | [NAME] | [NAME] | ARV | Repairs | Cash | Option | MLS | Notes
Spreadsheet: 212290d1360085288-create-a-sub-list-into-another-sheet-based-on-multiple-criteria-ef350_copy_data_2_criteria
Sheet: Data

Code 1 | Code 2 | [NAME] | Location | Prod Code | Product | Qty |  | seq
3A | AC | EAP | East | A12 | A/C | 2
3A | AC | WAP | West | A12 | A/C | 1
3A | RA | EAP | East | B06 | Battery | 2
3B | DC | EAP | East | B14 | [NAME] | 5
3B | AC | SAP | South | A12 | A/C | 3
4C | RA | SAP | South | B06 | Battery | 4
4C | RA | WAP | West | B22 | General Supply | 3
4C | AC | EAP | East | A12 | A/C | 2
Spreadsheet: 90170d1289931183-cannot-get-formulas-to-populate-a-protected-worksheet-when-inserting-rows-bcs-scope-list-template
Sheet: Building14

Building14
 | Reference No. | Year | Priority | BCS Reference | Items | Existing Conditions | Recommendations | New Const. | Additions | Alteration | Major Systems | Major Repair | Energy | Bond | Capital | Estimated Cost with Incidental
 |  | SITE ISSUES
 |  | ARCHITECTURAL ISSUES
 |  | MECHANICAL ISSUES
 |  | PLUMBING ISSUES
 |  | ELECTRICAL ISSUES
Spreadsheet: 875774d1722381191-help-with-if-statement-if-statement
Sheet: Sheet1

 |  | 1 |  | 2 |  | 3 |  | 4
 | Condition | Y |  | Y |  | N/A |  | N
 | Input 1 | 50000 |  | 50000 |  | 50000 |  | 50000
 | Input 2 | -80000 |  | 100000 |  | -80000 |  | -80000
 | Input 3 | 60000 |  | 60000 |  | 60000 |  | -60000
 | Final Result | 0 |  | 60000 |  | 60000 |  | -60000
 |  | If Condition = Y and Input 2 < 0, then final result = 0
 |  | If Condition = Y and Input2 > 0, then final result = Input 3
 |  | If Condition = N/A, then final result = Input 3
 |  | If Condition = N and Input3 < 0, then final result = Input 3, if not then it should = 0
Spreadsheet: 149845d1334159884-counting-same-values-in-a-column-countsamevalues
Sheet: Sheet1

1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
Spreadsheet: 675236d1588205911-looking-up-cell-value-based-on-whether-its-the-current-month-or-next-month-sample
Sheet: Summary

Monthly Finances
Fixed Expenses | Monthly Payment | Due Date
Spreadsheet: 884535d1733760919-calculating-leave-days-per-month-within-given-periods-absense
Sheet: Pivot_+_graph

PIVOT
Summer av Days absent | Type
Visible time | Digital Sick Leave | Self reported leave | Sick leave | Totalsum
2018 |  |  | 9 | 9
2019 | 28 | 51 |  | 79
2020 |  | 10 | 18 | 28
2021 |  |  | 69 | 69
2022 | 14 | 5 |  | 19
2023 | 21 | 14 |  | 35
november 2024 |  |  | 24 | 24
oktober 2024 | 22 |  |  | 22
september 2024 |  | 19 | 8 | 27
Totalsum | 85 | 99 | 128 | 312
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 66647 | 66187
2 | 71935 | 71189
3 | 69760 | 70180
4 | 77857 | 78842
5 | 66833 | 65685
6 | 75811 | 75245
7 | 75009 | 74971
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-09-30 00:00:00 |  |  | 48683
2001-10-07 00:00:00
CBS Volume
 |  |  | -32354
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: Central Gas

Central Gas
Originator |  | Commodity |  | Team |  | Total |  | %Total
Pollan |  | Gas |  | Central Gas |  | 87663
Frihart |  | Gas |  | Central Gas |  | 25620
Giron |  | Gas |  | Central Gas |  | 1250
Total
Spreadsheet: 99840d1298395167-vlookup-and-hlookup-sample
Sheet: Sheet1

Table 1
Account | Account_Name | Sales | Marketing | D&R
6001 | Royalties | 1250 | 1000 | 900
6002 | Temporary Labor | 300 | 124 | 100
6003 | Taxis/ Parking/Other | 250 | 33 | 400
6004 | Rail & Other Travel | 362 | 56 | 500
6005 | Airfare | 455 | 456 | 270
6006 | Car Rental | 125 | 652 | 580
6007 | Car Mileage | 750 | 180 | 520
6008 | Gasoline | 250 | 240 | 125
6009 | Meals | 1250 | 250 | 80
6010 | Entertainment | 100 | 100 | 160
6011 | Hotel / Accommodations | 1250 | 1000 | 340
6012 | Miscellaneous Travel | 125 | 1250 | 125
Table 2
Deparment | Account# | Account_Name | Value
Sales | 6001 | Royalties
Sales | 6002 | Temporary Labor
Sales | 6003 | Taxis/ Parking/Other
Sales | 6004 | Rail & Other Travel
Sales | 6005 | Airfare
Sales | 6006 | Car Rental
Sales | 6007 | Car Mileage
Sales | 6008 | Gasoline
Sales | 6009 | Meals
Sales | 6010 | Entertainment
Sales | 6011 | Hotel / Accommodations
Sales | 6012 | Miscellaneous Travel
Marketing | 6001 | Royalties
Marketing | 6002 | Temporary Labor
Marketing | 6003 | Taxis/ Parking/Other
Marketing | 6004 | Rail & Other Travel
Marketing | 6005 | Airfare
Marketing | 6006 | Car Rental
Marketing | 6007 | Car Mileage
Marketing | 6008 | Gasoline
Marketing | 6009 | Meals
Marketing | 6010 | Entertainment
Marketing | 6011 | Hotel / Accommodations
Marketing | 6012 | Miscellaneous Travel
D&R | 6001 | Royalties
D&R | 6002 | Temporary Labor
D&R | 6003 | Taxis/ Parking/Other
D&R | 6004 | Rail & Other Travel
D&R | 6005 | Airfare
D&R | 6006 | Car Rental
D&R | 6007 | Car Mileage
D&R | 6008 | Gasoline
D&R | 6009 | Meals
D&R | 6010 | Entertainment
D&R | 6011 | Hotel / Accommodations
D&R | 6012 | Miscellaneous Travel
Spreadsheet: 705825d1606321061-conditional-formatting-if-some-conditions-match-excelforum1333599book1111
Sheet: Sheet1

[NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13
T1 | Dewod | LOG | 1 | 291.3 | 292.65 | 309.85 | 285.5 | 294.05 | 295.65 | 300.14 | 1461205 | 33559
T2 | Dewod | LOG | 2 | 295.65 | 297 | 307.85 | 290 | 290.5 | 290.9 | 299.85 | 834491 | 17572
T3 | Dewod | LOG | 3 | 290.9 | 292 | 296.3 | 287.1 | 288.5 | 289.6 | 291.73 | 338885 | 7760
T4 | Dewod | LOG | 4 | 289.6 | 293 | 293.25 | 287.55 | 289.5 | 290.75 | 290.18 | 270134 | 4960
T5 | Dewod | LOG | 5 | 290.75 | 291.95 | 295.95 | 289.5 | 293 | 293.8 | 293.32 | 655749 | 10394
T6 | Dewod | LOG | 6 | 293.8 | 296.5 | 296.7 | 290.2 | 291.25 | 291.25 | 292.94 | 246510 | 4986 | Test 1 | 290.2 | 290.7
T7 | Dewod | LOG | 7 | 291.25 | 293.15 | 293.15 | 287.15 | 289.05 | 289.45 | 289.63 | 252697 | 5332 | Test 2 | 289.05 | 289.55
T8 | Dewod | LOG | 8 | 289.45 | 290 | 293 | 287.45 | 290.05 | 290.05 | 290.49 | 319302 | 8201
T9 | Dewod | LOG | 9 | 290.05 | 290.4 | 297.45 | 290 | 291.65 | 292.55 | 293.41 | 458829 | 7819
T10 | Dewod | LOG | 10 | 292.55 | 292 | 294 | 290.6 | 292.05 | 291.9 | 292.19 | 170188 | 3548
T11 | Dewod | LOG | 11 |  |  |  |  |  |  |  |  |  | Test 1 | 318.2 | 318.7
T12 | Dewod | LOG | 12 | 293.2 | 294.75 | 306.5 | 293.3 | 303.75 | 303.35 | 301.84 | 929976 | 20706 | Test 2 | 292.05 | 292.55
T13 | Dewod | LOG | 13 | 303.35 | 303.95 | 325 | 303.95 | 322 | 321.65 | 317.2 | 2047615 | 39419
T14 | Dewod | LOG | 14 | 321.65 | 319 | 337 | 318.2 | 327.15 | 327.75 | 328.97 | 1580688 | 32300
Spreadsheet: eric_saibi__9880__102201R
Sheet: Catawba 02

Owner Name |  | Duke Energy Corporation
Station Name |  | Catawba Nuclear Power Station
Unit Name |  | Catawba 02
NERC Region |  | SERC
State |  | SC
Fuel Type |  | Nuclear
Capacity |  | 1205 MW
Start Date |  | 2001-09-15 00:00:00
End Date |  | 2001-10-23 00:00:00
Prv. Start Date |  | 2001-09-15 00:00:00
Prv. End Date |  | 2001-10-20 00:00:00
Comments |  | Refueling
SIC |  | 4911
Plant ID |  | 1013575
Unit ID |  | 1008375
Outage ID |  | 10871
Spreadsheet: 07a2c3a8-5d39-4329-a37f-fdcfa90e3995
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 31. Asphalt supplied and placed, index numbers
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
Index Number ;  Weighted Average of 6 Capital Cities ;  ASPHALT SUPPLY ; |  |  | Original | A2314821C | 1979-09-01 00:00:00 | 2011-09-01 00:00:00 | 129 | Index Numbers | INDEX | Quarter | 3
Index Number ;  Weighted Average of 6 Capital Cities ;  ASPHALT PLACED ; |  |  | Original | A2314822F | 2000-06-01 00:00:00 | 2011-09-01 00:00:00 | 46 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 813489d1673812544-excel-formula-to-calculate-annualised-tax-annualised-tax
Sheet: Sheet1

 | I'm kindly asking for excel formula to calculate annualised tax. I have included the way  I calculate it manuarely but it is time consuming.
 | from | 0 | to | 120000 | 0
 | from | 120001 | to | 360000 | 0.2
 | from | 360001 | to | 720000 | 0.25
 | from | 720001 | to | 1440000 | 0.3
 | from | 1440001 | to | 3000000 | 0.35
 | from | 3000001 | and above |  | 0.4
 | Annual remuneration | 11000
 | Manual calculation
 |  | Cumulative amount taxed | Balance (Excess) | Gross Tax (PAYE)
 | 1 st 120,000.00 @ 0% | 120000 | (11,000,000.00-120,000.00) = 10,880,000.00 | 120,000.00 * 0% = 0
 | Next 240,000.00 @ 20% | 360000 | (10,880,000.00 - 240,000.00) = 10,640,000.00 | 240,000.00 * 20% =48,000.00
 | Next 360,000.00 @ 25% | 720000 | (10,640,000.00 -360,000.00) =10,280,000.00 | 360,000.00 * 25% =90,000.00
 | Next 720,000.00 @ 30% | 1440000 | (10,280,000.00 -720,000.00) =9,560,000.00 | 720,000.00 * 30% =216,000.00
 | Next 1,560,000.00 @ 35% | 3000000 | (9,560,000.00- 1,560,000.00)  = 8,000,000.00 | 1,560,000.00 * 35% =546,000.00
 | Final 8,000,000.00 @ 40% | 11000000 | (8,000,000.00- 8,000,000.00) = 0 | 8,000,000.00 * 40% =3,200,000.00
 | Total |  |  | 4100000
 | Desired answer
Spreadsheet: 85932d1285929938-tariff-prices-will-not-continue-to-calculate-when-24-hours-are-reached-king-edward-court-charges
Sheet: Sheet1

Carpark Arrival Date & Time
2010-10-01 11:18:00 |  | King [NAME] | SUNDAY - FRIDAY | SATURDAY
↑ |  | UP TO 1 HOUR | 2.2 | 2.5
ENTER ARRIVAL TIME HERE |  | 1 - 2 HOURS | 2.7 | 3
 |  | 2 - 3 HOURS | 3.8 | 3.8
Carpark Departure Date & Time |  | 3 - 4 HOURS | 5 | 5
 |  | 4 - 6 HOURS | 7 | 7
 |  | 6 - 24 HOURS | 15 | 15
Parking Duration | Description (Result)
 | Hours Parked
 | PARKING COST
↑
CHARGE THIS AMOUNT  TO GUEST ROOM
Spreadsheet: 99456d1298063840-delete-n-a-row-copy-of-sample1
Sheet: PERFORMANCE

 |  |  | [NAME] or [NAME] or [NAME] |  |  | Adam
Week | ID | Employee | Hour
Spreadsheet: 693608d1599056101-random-calculation-error-with-adding-and-subtracting-times-timesheet-problem
Sheet: Feb

February 2020
 |  |  | Hours worked |  |  |  |  | Total |  |  | Travel |  |  |  | Total |  |  | Adjustment | Adjusted total | Top-up | Total with top-up |  |  | Total hours |  |  |  |  |  | Overtime accrued
Date | Day | Day type | Morning |  | Afternoon |  | Private appointment |  |  |  | First travel |  | Second travel |  |  |  |  |  |  |  |  |  |  | Overall |  |  |  |  |  | Total
 |  |  | Start | Finish | Start | Finish |  |  |  |  | Start | Finish | Start | Finish |  |  |  |  |  |  |  |  |  | Total | Diff | Total | Diff | Total | Diff
2020-02-01 00:00:00 | Sat | Weekend
2020-02-02 00:00:00 | Sun | Weekend
2020-02-03 00:00:00 | Mon | Working day | 09:20:00 | 13:00:00 | 13:40:00 | 15:55:00 |  |  | 03:00:00
2020-02-04 00:00:00 | Tue | Working day | 09:30:00 | 12:00:00 | 12:30:00 | 16:10:00 |  |  | 00:45:00
2020-02-05 00:00:00 | Wed | Working day | 10:35:00 | 13:10:00 | 13:40:00 | 17:10:00 |  |  | 01:30:00
2020-02-06 00:00:00 | Thu | Working day | 08:00:00 | 10:45:00 | 12:00:00 | 15:20:00 |  |  | 01:00:00
2020-02-07 00:00:00 | Fri | Working day | 09:45:00 | 15:55:00 |  |  |  |  | 02:00:00
2020-02-08 00:00:00 | Sat | Weekend
2020-02-09 00:00:00 | Sun | Weekend
2020-02-10 00:00:00 | Mon | Working day | 10:05:00 | 12:15:00 | 13:00:00 | 16:30:00 |  |  | 03:00:00
2020-02-11 00:00:00 | Tue | Working day | 10:25:00 | 16:40:00 |  |  |  |  | 02:00:00
2020-02-12 00:00:00 | Wed | Working day | 11:00:00 | 17:10:00 |  |  |  |  | 02:40:00
2020-02-13 00:00:00 | Thu | Working day | 10:20:00 | 17:00:00 |  |  |  |  | 02:00:00
2020-02-14 00:00:00 | Fri | Working day | 09:25:00 | 13:30:00 | 14:15:00 | 16:00:00 |  |  | 00:45:00
2020-02-15 00:00:00 | Sat | Weekend
2020-02-16 00:00:00 | Sun | Weekend
2020-02-17 00:00:00 | Mon | Working day | 08:30:00 | 12:00:00 | 12:30:00 | 15:05:00 |  |  | 01:00:00
2020-02-18 00:00:00 | Tue | Working day | 09:25:00 | 12:30:00 | 13:00:00 | 16:10:00 |  |  | 02:00:00
2020-02-19 00:00:00 | Wed | Working day | 09:40:00 | 15:40:00 |  |  |  |  | 03:00:00
2020-02-20 00:00:00 | Thu | Working day | 10:20:00 | 16:50:00 |  |  |  |  | 03:00:00
2020-02-21 00:00:00 | Fri | Working day | 09:15:00 | 15:05:00 |  |  |  |  | 03:00:00
2020-02-22 00:00:00 | Sat | Weekend
2020-02-23 00:00:00 | Sun | Weekend
2020-02-24 00:00:00 | Mon | Working day | 10:05:00 | 16:00:00 |  |  |  |  | 00:30:00
2020-02-25 00:00:00 | Tue | Working day | 10:20:00 | 16:05:00 |  |  |  |  | 01:00:00
2020-02-26 00:00:00 | Wed | Working day | 11:50:00 | 16:30:00 |  |  |  |  | 02:00:00
2020-02-27 00:00:00 | Thu | Working day | 10:50:00 | 18:00:00 | 18:30:00 | 21:30:00 |  |  | 02:00:00 |  | 09:20:00 | 10:50:00 | 21:30:00 | 22:45:00
2020-02-28 00:00:00 | Fri | Working day | 09:40:00 | 12:55:00 |  |  |  |  | 01:30:00
2020-02-29 00:00:00 | Sat | Weekend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To carry forward:
 |  | Signatures
 |  | Employee |  |  |  |  |  | For ALLEA
 |  | Date |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | (type name here)
 |  |  |  |  |  |  |  |  | (type job title here)