tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871238d1717616655-lookup-table-to-determine-unit-price-using-width-length-and-quantity-revised-test-file
Sheet: Sheet2

 |  |  | Variable Length Range
 |  | UP TO 9" | 9" TO 15 1/2" | 15 1/2" TO 22" | 22" TO 28 1/2" | 28 1/2" TO 35" | 35" TO 41 1/2" | 41 1/2" TO 48" | 48" TO 54 1/2" | 54 1/2" TO 61" | 61" TO 67 1/2" | 67 1/2" TO 74"
WIDTH | QUANTITY | 0 | 9 | 15 | 22 | 28 | 35 | 41 | 48 | 54 | 61 | 67
0.07 | 0 | 4.883839760000001 | 6.04114776 | 7.39519812 | 8.59879844 | 9.57093716 | 10.97127984 | 12.66094952 | 13.52893052 | 14.73253084 | 15.65837724 | 17.19759688
 | 5 | 4.108443400000001 | 5.08058212 | 6.226317040000001 | 7.534075080000001 | 8.05486368 | 9.22374476 | 11.1101568 | 11.59622616 | 12.41791484 | 13.91084216 | 14.68623852
 | 10 | 3.390912440000001 | 4.582939680000001 | 5.3236168 | 6.712386400000001 | 7.360478880000001 | 8.679810000000002 | 9.848691080000002 | 10.28846812 | 11.06386448 | 11.64251848 | 13.05443424
 | 50 | 2.81225844 | 3.77282408 | 4.629232000000001 | 5.9022708 | 7.244748080000001 | 7.730817440000001 | 8.899698520000003 | 9.270037080000002 | 10.38105276 | 11.21431452 | 12.41791484
0.125 | 0 | 5.35833604 | 6.712386400000001 | 8.216886800000001 | 9.929702640000002 | 10.62408744 | 12.151734 | 14.6399462 | 15.31118484 | 16.3759082 | 18.35490488 | 19.3270436
 | 5 | 4.525074280000001 | 5.65923612 | 6.920701840000001 | 8.35576376 | 8.945990840000002 | 10.2421758 | 12.31375712 | 12.89241112 | 13.78353828 | 15.46163488 | 16.22545816
 | 10 | 3.77282408 | 5.08058212 | 5.9022708 | 7.487782760000001 | 8.008571360000001 | 9.605656400000003 | 10.91341444 | 11.3994838 | 12.27903788 | 12.93870344 | 14.44320384
 | 50 | 3.28675472 | 4.20102804 | 5.219459080000001 | 6.619801760000001 | 7.6382328 | 8.59879844 | 9.270037080000002 | 10.28846812 | 11.56150692 | 12.22117248 | 13.60994208
0.188 | 0 | 6.909128760000001 | 9.420487120000002 | 11.26060684 | 13.47106512 | 17.39433924 | 19.0377166 | 21.16716332 | 24.15301796 | 25.99313768 | 30.86540436000001 | 32.85597412000001
 | 5 | 5.79811308 | 7.927559800000001 | 9.46677944 | 11.90869932 | 14.6399462 | 16.0287158 | 17.79939704000001 | 20.35704772 | 21.88469428000001 | 25.99313768 | 27.64808812
 | 10 | 5.16159368 | 7.059578800000001 | 8.506213800000001 | 10.73981824 | 13.1354458 | 14.42005768 | 16.91984296 | 18.30861256 | 20.78525168000001 | 23.3776216 | 24.88212200000001
 | 50 | 4.54822044 | 6.990140320000001 | 7.973852120000001 | 10.04543344 | 12.36004944 | 13.52893052 | 15.94770424 | 17.19759688 | 19.3270436 | 21.73424424 | 23.18087924
Std widths | Variable Qty Range |  | End result to find price based on the Width, Length & Quantity
 | Example:
 | [NAME] | 0.13 | (input)
 | Qty | 15 | (input)
 | Length | 22.5 | (input)
 | Expected Outcome | 5.3236168 | (output)
Spreadsheet: 167347d1341955697-excel-2007-calculating-sick-hours-out-of-a-forty-hour-work-week-employees-sick-hrs-nicks-version
Sheet: 2007

Employees Sick Hours for the year 2007
Name | Allowed Hrs | Date | Used Hrs | Remaining Hrs
Arielle | 40 | 2007-01-03 00:00:00 | 8 | 32
 |  | 2007-01-04 00:00:00 | 8 | 24
 |  | 2007-01-05 00:00:00 | 8 | 16
 |  | 2007-02-20 00:00:00 | 3 | 13
 |  | 2007-05-10 00:00:00 | 0.5 | 12.5
 |  | 2007-05-11 00:00:00 | 1.4 | 11.1
 |  | 2007-07-07 00:00:00 | 11.1 | 0
Fellicia | 40 | 2007-02-12 00:00:00 | 8 | 32
 |  | 2007-05-07 00:00:00 | 8 | 24
 |  | 2007-05-14 00:00:00 | 6 | 18
 |  | 2007-06-04 00:00:00 | 8 | 10
 |  | 2007-07-09 00:00:00 | 8 | 2
[NAME] | 40 | 2007-04-17 00:00:00 | 8 | 32
 |  | 2007-09-14 00:00:00 | 8 | 24
 |  | 2007-10-31 00:00:00 | 8 | 16
 |  | 2007-11-01 00:00:00 | 8 | 8
[NAME] | 40 | 2007-02-28 00:00:00 | 8 | 32
 |  | 2007-05-02 00:00:00 | 4.15 | 27.85
 |  | 2007-09-14 00:00:00 | 8 | 19.85
 |  | 2007-12-20 00:00:00 | 3.25 | 16.6
[NAME] | 40 | 2007-01-30 00:00:00 | 8 | 32
 |  | 2007-11-26 00:00:00 | 6.15 | 25.85
 |  | 2007-11-27 00:00:00 | 8 | 17.85
 |  | 2007-11-28 00:00:00 | 8 | 9.850000000000001
[NAME] | 40 | 2007-01-05 00:00:00 | 8 | 32
Avi | 40
Mira | 40
[NAME] | 30 | 2007-04-16 00:00:00 | 6 | 24
 |  | 2007-06-05 00:00:00 | 3.45 | 20.55
 |  | 2007-06-21 00:00:00 | 2.45 | 18.1
 |  | 2007-09-04 00:00:00 | 2.2 | 15.9
 |  | 2007-09-05 00:00:00 | 2.15 | 13.75
Nicol | 40 | 2007-05-14 00:00:00 | 8 | 32
 |  | 2007-05-22 00:00:00 | 8 | 24
 |  | 2007-07-25 00:00:00 | 8 | 16
 |  | 2007-08-28 00:00:00 | 8 | 8
 |  | 2007-09-25 00:00:00 | 8 | 0
Kristen | 40 | 2007-02-12 00:00:00 | 8 | 32
 |  | 2007-05-15 00:00:00 | 8 | 24
 |  | 2007-07-09 00:00:00 | 8 | 16
 |  | 2007-10-10 00:00:00 | 8 | 8
[NAME] | 40 | 2007-08-17 00:00:00 | 8 | 32
 |  | 2007-10-04 00:00:00 | 8 | 24
 |  | 2007-10-08 00:00:00 | 8 | 16
 |  | 2007-10-09 00:00:00 | 8 | 8
 |  | 2007-10-10 00:00:00 | 8 | 0
Rebecca | 40
[NAME] | 40 | 2007-09-06 00:00:00 | 8 | 32
 |  | 2007-12-21 00:00:00 | 8 | 24
Spreadsheet: 716571d1612274973-how-to-use-index-match-to-cross-reference-two-lists-please-help-employee-complaints
Sheet: 2019

Employee | Complaints
Employee 1 | 1
Employee 2 | 3
Employee 3 | 6
Employee 4 | 1
Employee 5 | 2
Employee 6 | 1
Employee 7 | 0
Employee 8 | 4
Employee 9 | 5
Employee 10 | 7
Employee 11 | 1
Employee 12 | 4
Employee 13 | 2
Employee 14 | 2
Employee 15 | 4
Employee 16 | 6
Employee 17 | 7
Employee 18 | 5
Employee 19 | 2
Spreadsheet: 785032d1656091801-index-match-with-multiple-criteria-but-output-value-on-different-row-2022-06-24-oeldere-kingofcamden-example-1-
Sheet: Blad1

TABLE | Kenmerk | [NAME] |  |  |  | Aantal [NAME] | Kolomlabels
Value1 | Output1 |  |  |  |  | Rijlabels | Value1 | Value2 | Value3 | Eindtotaal
Value1 | Output2 |  |  |  |  | Output1 | 1 |  | 1 | 2
Value1 | Output3 |  |  |  |  | Output2 |  |  | 1 | 1
Value1 | Output4 |  |  |  |  | Output3 |  |  | 2 | 2
Value1 | Output5 |  |  |  |  | Output4 | 2 |  | 1 | 3
Value1 | … |  |  |  |  | Output5 | 2 |  |  | 2
Value2 | Output1 |  |  |  |  | Eindtotaal | 5 |  | 5 | 10
Value2 | Output2
Value2 | Output3
Value2 | Output4
Value2 | Output5
Value2 | …
Value3 | Output1 | Y
Value3 | Output2
Value3 | Output3
Value3 | Output4 | Z
Value3 | Output5
Value3 | …
Value1 | Output1
Value1 | Output2
Value1 | Output3
Value1 | Output4 | X
Value1 | Output5 | Y
Value1 | …
Value2 | Output1
Value2 | Output2
Value2 | Output3
Value2 | Output4
Value2 | Output5
Value2 | …
Value3 | Output1
Value3 | Output2 | Z
Value3 | Output3 | Y
Value3 | Output4
Value3 | Output5
Value3 | …
Value1 | Output1 | X
Value1 | Output2
Value1 | Output3
Value1 | Output4 | Y
Value1 | Output5 | X
Value1 | …
Value2 | Output1
Value2 | Output2
Value2 | Output3
Value2 | Output4
Value2 | Output5
Value2 | …
Value3 | Output1
Value3 | Output2
Value3 | Output3 | Y
Value3 | Output4
Value3 | Output5
Value3 | …
… | Output1
… | Output2
… | Output3
… | Output4
… | Output5
… | …
Spreadsheet: 844139d1695914091-is-there-a-way-to-force-the-index-function-to-return-cell-references-instead-of-values-test-2b-bird333-
Sheet: detail

 | Yardi | -272.1 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -230 | 0101017
 | Yardi | -224.54 | 0101017
 | Yardi | -191.94 | 0101017
 | Yardi | -173.27 | 0101017
 | Yardi | -139 | 0101017
 | Yardi | -124.8 | 0101017
 | Yardi | -88.3 | 0101017
 | Yardi | -68.62 | 0101017
 | Yardi | -42.83 | 0101017
 | Yardi | -40.31 | 0101017
 | Yardi | -38.88 | 0101017
 | Yardi | -32.39 | 0101017
 | Yardi | -32.1 | 0101017
 | Yardi | -19.61 | 0101017
 | Yardi | -5.77 | 0101017
 | Yardi | -5.2 | 0101017
 | Yardi | 0.02 | 0101017
 | Yardi | 0.02 | 0101017
 | Yardi | 0.03 | 0101017
 | Yardi | 0.06 | 0101017
 | Yardi | 0.07 | 0101017
 | Yardi | 0.08 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | -272.09 | 0101017
Spreadsheet: 375983d1423433314-conditional-formatting-how-to-leave-blank-cells-blank-no-colour-until-date-populated-training-dates-for-excel-forum
Sheet: Sheet2

Operations | Forklift | IPAF | CSR | CPC | First Aid | [NAME] | Manual Handling | Otis | Lifting Modules 1 2 3 | Loading with chains
1 | 2013-09-29 00:00:00 | 2015-03-17 00:00:00 |  |  | 2017-12-26 00:00:00
2 | 2016-08-07 00:00:00 | 2019-01-14 00:00:00
3 | 2016-10-25 00:00:00 | 2019-03-20 00:00:00
4 | 2014-02-21 00:00:00 | 2017-03-08 00:00:00
5 | 2016-07-02 00:00:00 | 2019-02-20 00:00:00
6 | 2014-02-20 00:00:00 | 2018-11-06 00:00:00
7 |  | 2018-11-06 00:00:00
8 |  | 2017-03-08 00:00:00
9 | 2009-04-05 00:00:00 | 2020-02-05 00:00:00
10 | 2015-03-19 00:00:00 | 2020-01-12 00:00:00
11 |  | 2019-09-17 00:00:00
12 |  | 2020-01-28 00:00:00
13 |  | 2019-10-15 00:00:00
14 | 2013-10-07 00:00:00 | 2016-08-23 00:00:00
15 | 2017-10-01 00:00:00 | 2019-10-15 00:00:00
16 | 2016-11-26 00:00:00 | 2020-01-28 00:00:00
17
Spreadsheet: chris_germany__2019__Tenn Invoice Summary
Sheet: Prior Amount-Detail

ENA CORP
Invoice Date: | 2002-01-14 00:00:00
December. 2001 | Cashout Imbalance |  | Contract 80045 SA
 |  |  |  |  |  |  | Dec. 2001
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals
Dec. 2001 | 11712 | 14570 | 7984 |  |  |  | Cash Out | 31446.72 | 39439.53 | 21437.04
Totals |  |  |  |  |  |  | Level Charge | 15204.62 | 16224.48 | 5568.23
PRIOR MONTHS
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals | Average $/Unit
Apr. 2001 |  | -10380 |  |  |  |  | Apr. 2001 |  | -54882.82
Mar.2001 |  | -4452 |  |  |  |  | Mar.2001 |  | -22458.11
Feb.2001 |  | -8226 |  |  |  |  | Feb.2001 |  | -43338.68
Jan.2001 |  | -39989 |  |  |  |  | Jan.2001 |  | -299589.96
Dec. 2000 |  | -34699 |  |  |  |  | Dec. 2000 |  | -279045.98
Nov.2000 |  | -21773 |  |  |  |  | Nov.2000 |  | -115396.9
Oct.2000 |  | -15350 |  |  |  |  | Oct.2000 |  | -73108.75
Totals |  |  |  |  |  |  | Totals
ENA CORP
Invoice Date: | 2002-12-13 00:00:00
November. 2001 | Cashout Imbalance |  | Contract 80045 SA
 |  |  |  |  |  |  | Nov.2001
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals
Nov. 2001 | 540 | -472 | 9361 |  |  |  | Cash Out | 1342.01 | -1173.2 | 27117.88
Totals |  |  |  |  |  |  | Totals
PRIOR MONTHS
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals | Average $/Unit
May. 2001 | 0 | -16452 | 0 |  |  |  | Cash Out | 0 | -70774.85 | 0
Totals |  |  |  |  |  |  | Totals
ENA UPSTREAM
Invoice Date: | 2002-12-13 00:00:00
November. 2001 | Cashout Imbalance |  | Contract 80357 SA
 |  |  |  |  |  |  | Nov.2001
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals
Nov. 2001 | 4045 | 36925 | 53491 |  |  |  | Cash Out | 11707.04 | 107208.05 | 156161.63
Totals |  |  |  |  |  |  | Totals
PRIOR MONTHS
Cashout MDQ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals |  |  | Cashout $ | Zone 0, 100 | Zone L, 800 | Zone L, 500 | Totals | Average $/Unit
Oct.2001 |  | -173 | -117 |  |  |  | Oct.2001 |  | -387.99 | -297.85
Aug.2001 |  | 27436 |  |  |  |  | Aug.2001 |  | 82760.17
Jul.2001 |  | -180 |  |  |  |  | Jul.2001 |  | -556.27
Totals | 0 |  | 0 |  |  |  | Totals | 0 |  | 0
Spreadsheet: 024b8a1e-dd68-4a6f-964f-e3126be68a93
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 |  |  |  |  | City and County of Denver
 |  |  |  |  | Exemplary Performance Request
 |  | Instructions
 |  |  |  | After filling out this Exemplary Performance Request form, please send to the Controller's Office, Payroll Division at: 201 [NAME]. 1109; Denver, CO 80202 or save as and then email to [EMAIL] or fax to [PHONE].
 |  |  |  | Per CS Rule 10-67B, effective 1/1/2011, employees that are covered by CS Rules are eligible to be granted, and use, up to 20 hours per calendar year for exemplary performance for outstanding contributions to the Agency.
 |  | Employee Information |  |  | All fields in the section must be completed.
 |  |  |  |  | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Department/Agency |  |  |  |  |  |  |  |  | Employee ID Number |  |  |  |  |  |  | [NAME] Number
 |  | [NAME]
 |  |  |  | Please credit the above listed employee |  |  |  |  |  |  |  |  |  |  |  |  | hours of Exemplary Performance.
 |  |  |  | Effective Date:
 |  | Comments
 |  | Payroll Division  Use Only
 |  |  |  |  | Per CS Rule 10-67B, effective 1/1/2011, employees that are covered by CS Rules are eligible to be granted, and use, up to 20 hours per calendar year for exemplary performance for outstanding contributions to the Agency.
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | has been granted |  |  |  |  |  |  | hours this calendar year.
Spreadsheet: cb3e7e01-efb3-4e5e-ae6f-a1ba5a40c261
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
FBERY | Test | FBERY | Beryllium, Blood | Beryllium | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Blood Draw blood in a metal free, royal blue-top with EDTA tube(s), and send 2 mL of EDTA whole blood  refrigerated. | 0.3 mL Note:  Submission of the | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range: <1.0 ng/mL                                                 Test Performed By: Medtox Laboratories, Inc. 402 West County Road D St. Paul, MN  55112 | Monday through Sunday | 3 days | 5-7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc
FBERY | [NAME] | WBEDTAMF | [NAME] EDTA - Metal Free (ERB) |  |  |  | Refrigerated
FBERY | Result | Z1177 | Beryllium | Beryllium | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 56547d1256731625-forecast-closing-stock-formula-more-than-8-if-statements-problem-closing_stock_calculation
Sheet: Sheet1

 | Week | forecast Sales at Cost Price | Target days of stock | Closing Stock
 | 1 | 2000000 | 30 | 11142857.14285714
 | 2 | 3000000 | 35 | 14000000
 | 3 | 1500000 | 49 | 16000000
 | 4 | 2000000 | 55 | 0
 | 5 | 3500000 | 55 | 0
 | 6 | 4000000 | 55 | 0
 | 7 | 3000000
 | 8 | 2000000
 | 9 | 1500000
 | 10 | 1500000
Spreadsheet: 94780d1294545350-excel-2007-search-2-columns-for-matching-surname-surname-search
Sheet: Sheet1

 | [NAME] |  | [NAME]
 | A smith |  | r Marcianno
 | A D Smith |  | H G wells
 | Mr A Smith |  | [NAME]
 | [NAME] |  | G Bristol
 | [NAME] |  | W W Well
 | AD wellington |  | B Bridgewater
 | Lord Wellington |  | J S Bach
 | C Clay |  | A G Smith
 | Cassius Clay |  | [NAME]
 | [NAME]
 | Rocky marcianno
 | r Wells
 | G Clayton
 | [NAME]
Spreadsheet: 155796d1337054395-creating-individual-student-reports-book3
Sheet: Sheet1

Grade | Class Ref | ESIS / School  Number | Name | Arabic Names | 2011-09-11 00:00:00 | 2011-09-18 00:00:00 | 2011-09-25 00:00:00 | 2011-10-02 00:00:00 | 2011-10-09 00:00:00 | 2011-10-16 00:00:00 | 2011-10-23 00:00:00 | 2011-10-30 00:00:00 | 2011-11-06 00:00:00 | 2011-11-13 00:00:00 | 2011-11-20 00:00:00 | 2011-11-27 00:00:00 | 2011-12-04 00:00:00 | 2011-12-11 00:00:00 | 2011-12-18 00:00:00 | 2011-12-25 00:00:00 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2011-09-11 00:00:00 | 2011-09-18 00:00:00 | 2011-09-25 00:00:00 | 2011-10-02 00:00:00 | 2011-10-09 00:00:00 | 2011-10-16 00:00:00 | 2011-10-23 00:00:00 | 2011-10-30 00:00:00 | 2011-11-06 00:00:00 | 2011-11-13 00:00:00 | 2011-11-20 00:00:00 | 2011-11-27 00:00:00 | 2011-12-04 00:00:00 | 2011-12-11 00:00:00 | 2011-12-18 00:00:00 | 2011-12-25 00:00:00 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | Number of P | Number of A | Number of AA | Number of U | Average Grade
9 | 1 | 1011110043 | ABDULLA | عبدالله | AA | P | P | P | P | P | P | P | H | P | P | P | P | EX | H | H | A | P | P | A | P | P | P | P | P | P | P | P | EX | H | P | P | P |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | C | C | [NAME] | [NAME] |  |  |  | 0 | 65 | 65 | 0 | 65 | 60 | 50 | 65 | 55 | 55 | 40 | 60 |  |  | 50 | 60 | 50 |  |  |  |  | 49.33333333333334
Spreadsheet: 829713d1684406478-excel-formula-to-calculate-period-in-months-and-days-between-two-dates-vat-before-registration-2
Sheet: Sheet1

 | Kindly asking for excel formula that calculate the period between two dates in months and days as shown in desired solution in column E and F
 | Also the formula for narrations on column F - If number of months is more than 6 - No input tax and if is 6 months or less - Claim input tax credit
 | Purchese | Date of Purchase | Date VAT Registered | Number of months | VAT Implication
 | Stationery | 2021-06-02 00:00:00 | 2022-01-01 00:00:00 |  | No input tax credit
 | Double cab vehicle | 2021-09-09 00:00:00 | 2022-01-01 00:00:00 |  | Claim input tax credit |  | 3 months, 23 days
 | Computer desk | 2021-06-16 00:00:00 | 2022-01-01 00:00:00 |  | No input tax credit |  | 6 months, 16 days
 | 20 Laptops | 2021-09-09 00:00:00 | 2022-01-01 00:00:00 |  | Claim input tax credit |  | 3 months, 23 days
 | Office cartridges | 2021-09-30 00:00:00 | 2022-01-01 00:00:00 |  | Claim input tax credit |  | 3 months, 2 days
Spreadsheet: e6c3c6a9-a769-4fda-a646-13951dd2ff42
Sheet: Sheet1

Total  Emergency Department Visits, Maine, 2009, by Sex and Age | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME] |  | Number | Crude Rate |  | Age-adjusted Rate
 |  |  | Rate | 95% CI | Rate | 95% CI
Total |  | 699099 | 53030.3 | 52906 -  53154.6 | 53808.8 | 53682.7 -  53934.9
Sex
 | Male | 323148 | 50211 | 50037.9 -  50384.1 | 51413.6 | 51236.3 -  51590.9
 | Female | 375951 | 55719.5 | 55541.4 -  55897.6 | 56365.8 | 56185.6 -  56546
Age
 | < 1 year | 11309 | 82313.12 | 80803.0 - 83844.4 | NApp | NApp
 | 1 - 4 years | 35078 | 61515.53 | 60873.4 - 62162.7 | NApp | NApp
 | 5 - 9 years | 26250 | 36367.41 | 35928.8 - 36810.1 | NApp | NApp
 | 10 - 14 years | 28093 | 36727.68 | 36299.4 - 37159.7 | NApp | NApp
 | 15 - 24 years | 113438 | 66690.18 | 66373.2 -  67078.3 | NApp | NApp
 | 25 - 34 years | 100265 | 67002.8 | 66588.7 - 67418.8 | NApp | NApp
 | 35 - 44 years | 89536 | 51825.01 | 51486.1 - 52165.6 | NApp | NApp
 | 45 - 54 years | 90340 | 41587.83 | 41317.1 - 41859.9 | NApp | NApp
 | 55 - 64 years | 68038 | 37074.09 | 36796.0 - 37353.7 | NApp | NApp
 | 65 - 74 years | 53176 | 49044.94 | 48629.0 - 49463.6 | NApp | NApp
 | 75 - 84 years | 52391 | 76143.07 | 75492.4 - 76797.9 | NApp | NApp
 | 85 + years | 31208 | 109933.77 | 108717.4 - 111160.3 | NApp | NApp
Data Source: Maine Hospital Inpatient and Outpatient Databases; Maine Health Data Organization. Total Emergency Department Visits is defined as all emergency department visits with ED revcode or outpatient ED flag (ICD9-CM codes: 0450-0459). Crude rates are ED visits per 100,000 population. Age-adjusted rates are ED visits per 100,000 population age-adjusted to the U.S. 2000 standard population. 95% CI: 95% confidence interval of the rate. N/A= Not applicable.
Total Emergency Department Visits is defined as all emergency department visits with ED revcode or outpatient ED flag (ICD9-CM codes: 0450-0459).
Crude rates are ED visits per 100,000 population.
Age-adjusted rates are ED visits per 100,000 population age-adjusted to the U.S. 2000 standard population.
95% CI: 95% confidence interval of the rate.
Spreadsheet: 803432d1667463755-circular-references-formula-errors-date-calculation-sample1
Sheet: Sheet

(2) Start - schedule date |  OVERDUE Days | (5) Finish - Target date |  DELAY Days | Target Day to complete job | WO ID | EQUIPMENT | Equipment Description | JOB_TYPE | Job ID | Job Description | ZONE | WO Status | SCHEDULE_MONTH | SCHEDULE_DATE | TARGET_DATE | START_DATE | START_TIME | FINISH_DATE | FINISH_TIME
 |  |  |  |  |  | PM |  |  |  |  |  | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 0.5833333333333334 | 2022-10-04 00:00:00 | 0.7708333333333334
 |  |  |  |  |  | PM |  |  |  |  |  | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 0.7604166666666666 | 2022-10-04 00:00:00 | 0.8125
Spreadsheet: 837166d1689895311-how-can-i-get-data-from-another-sheet-with-formula-rotation-schedule-multiple-employees-1-edited
Sheet: Rotation

Work Rotation Schedule - Multiple Employees
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | © 2013-2021 Vertex42 LLC
Year |  |  | Month |  |  |  |  |  |  |  |  |  | Shift Schedule |  |  |  |  |  |  | D | N | A | B | x |  | V | S | P |  |  |  |  |  |  |  |  |  |  |  | [NAME] can change the letters in cells U3:[NAME] (if using numbers, enter them as text like '4)
2022 |  |  | 1
Non Working Days |  |  | Start Day |  |  |  |  |  |  |  |  |  |  |  | Starting | 2022-01-01 00:00:00
Holidays only |  |  | 1 |  |  | 1:Sun, 2:Mon
 |  |  | Work Rotation Schedule
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] can hide rows that you do not need
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] new employee rows below this one
Employee 1 | xDDDDxxxxNNNNxxx
Employee 2 | xNNNNxxxxDDDDxxx
Employee 3 | NxxxxDDDDxxxxNNN
Employee 4 | DxxxxNNNNxxxxDDD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] new employee rows above this one
Non Working Days |  | Code | Weekend1 | Weekend2
None |  | 0000000 | 0 | 0
Holidays only |  | 0000000 | 0 | 0
Saturday, Sunday |  | 1 | 7 | 1
Sunday, Monday |  | 2 | 1 | 2
Monday, Tuesday |  | 3 | 2 | 3
Tuesday, Wednesday |  | 4 | 3 | 4
Wednesday, Thursday |  | 5 | 4 | 5
Thursday, Friday |  | 6 | 5 | 6
Friday, Saturday |  | 7 | 6 | 7
Sunday only |  | 11 | 1 | 0
Monday only |  | 12 | 2 | 0
Tuesday only |  | 13 | 3 | 0
Tuesday only |  | 13 | 4 | 0
Wednesday only |  | 14 | 5 | 0
Thursday only |  | 15 | 6 | 0
Friday only |  | 16 | 7 | 0
Tuesday only |  | 13 | 8 | 0
Saturday only |  | 17 | 9 | 0
CHOSEN