tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: matt_motley__26413__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-13 00:00:00 | 16 | 17.25 | 16 | 17.25
Mid-Columbia | 2002-01-13 00:00:00 | 16 | 17.25 | 16 | 17.25
COB | 2002-01-13 00:00:00 | 15 | 17.75 | 15 | 17.75
N. California | 2002-01-13 00:00:00 | 15 | 18 | 15 | 18
Midway/Sylmar | 2002-01-13 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-13 00:00:00 | 14.5 | 19.5 | 14.5 | 19.5
Mead | 2002-01-13 00:00:00 | 16.5 | 18 | 16.5 | 18
Palo Verde | 2002-01-13 00:00:00 | 15 | 18.25 | 15 | 18.25
Inland SW | 2002-01-13 00:00:00 | 15 | 18.25 | 15 | 18.25
4-Corners | 2002-01-13 00:00:00 | 15 | 16.5 | 15 | 16.5
Central Rockies | 2002-01-13 00:00:00 | 12.75 | 14.5 | 12.75 | 14.5
NW/N. Rockies | 2002-01-14 00:00:00 | 18.5 | 19.25 | 16 | 17.25
Mid-Columbia | 2002-01-14 00:00:00 | 18.5 | 19.25 | 16 | 17.25
COB | 2002-01-14 00:00:00 | 19.5 | 21.5 | 15 | 17.75
N. California | 2002-01-14 00:00:00 | 21 | 22.5 | 15 | 18
Midway/Sylmar | 2002-01-14 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-14 00:00:00 | 21.5 | 23 | 14.5 | 19.5
Mead | 2002-01-14 00:00:00 | 21 | 21.75 | 16.5 | 18
Palo Verde | 2002-01-14 00:00:00 | 20.25 | 22.25 | 15 | 18.25
Inland SW | 2002-01-14 00:00:00 | 20.25 | 22.25 | 15 | 18.25
4-Corners | 2002-01-14 00:00:00 | 20.5 | 21 | 15 | 16.5
Central Rockies | 2002-01-14 00:00:00 | 18.75 | 21 | 12.75 | 14.5
Spreadsheet: 797659d1664027197-conditional-format-lowest-number-in-a-range-but-some-numbers-divided-by-2-conditional-format-bikes-hd
Sheet: Sheet1

cumulative stock
per bike |  | jan | feb | [NAME] | apr | may | jun
1 | frames | 2 | 2 | 3 | 5 | 7 | 9
2 | wheels | 3 | 4 | 7 | 8 | 12 | 18
1 | chains | 2 | 3 | 3 | 4 | 5 | 9
total bikes |  | 1 | 2 | 3 | 4 | 5 | 9
Spreadsheet: 346863d1411384973-numbering-and-segmenting-numbering-and-segmenting-2
Sheet: Sheet1

3001-001 | 10 | 1
3001-002 | 10
3001-003 | 5
3001-004 | 7
Spreadsheet: john_griffith__15739__10_16_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 255 | 28.5 | 30.5 | 84.7 | 90.7 | 14.06 | 2001-10-16 10:15:00
 | NG Z1 | 280 | 52.5 | 53.5 | 69.7 | 71.1 | 12.39 | 2001-10-16 10:15:00
 | NG F2 | 295 | 71 | 73 | 69.2 | 71.1 | 13.01 | 2001-10-16 10:15:00
 | NG G2 | 295 | 81 | 83 | 65.5 | 67.2 | 12.31 | 2001-10-16 10:15:00
 | NG H2 | 295 | 80 | 83 | 57.6 | 59.8 | 10.89 | 2001-10-16 10:15:00
 | NG J2 | 280 | 73 | 77 | 50.5 | 53.3 | 9.14 | 2001-10-16 10:15:00
 | NG K2 | 285 | 74 | 79 | 46.2 | 49.4 | 8.56 | 2001-10-16 10:15:00
 | NG M2 | 290 | 80 | 85 | 45.5 | 48.4 | 8.56 | 2001-10-16 10:15:00
 | NG N2 | 290 | 84 | 89 | 45.2 | 48 | 8.5 | 2001-10-16 10:15:00
 | NG Q2 | 295 | 91 | 95 | 45.7 | 47.8 | 8.67 | 2001-10-16 10:15:00
 | NG U2 | 295 | 95 | 100 | 45.5 | 47.9 | 8.66 | 2001-10-16 10:15:00
 | NG V2 | 300 | 99 | 105 | 44.7 | 47.5 | 8.69 | 2001-10-16 10:15:00
 | [NAME] |  |  |  |  |  |  | 2001-10-15 14:41:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 701554d1603810485-summ-if-column-header-matches-summ
Sheet: Sheet

 |  |  |  |  |  |  |  | Selection criteria (yellow for manual input)
 |  |  |  |  |  |  |  |  |  | Select year | Comment
 |  |  |  |  |  |  |  | Annual revenue year | 2020 | 1 | 1 = include in the calculation
 |  |  |  |  |  |  |  |  | 2021 | 0 | 0 = exclude from the calculation
 |  |  |  |  |  |  |  |  | 2022 | 1
 |  |  |  |  |  |  |  |  |  | Select year | Comment
 |  |  |  |  |  |  |  | Project year | 2020 | 1 | 1 = include in the calculation
 |  |  |  |  |  |  |  |  | 2021 | 0 | 0 = exclude from the calculation
 |  |  |  |  |  |  |  | Customer | Auchan
 |  |  |  |  |  |  |  | Manager | [NAME]
 |  |  |  |  |  |  |  |  | My effort (incorrect) | Must be (correct)
 |  |  |  |  |  |  |  | Variant 1
 |  |  |  | Annual revenue
Project year | Customer | Manager | Region | 2020 | 2021 | 2022
2020 | Restore | [NAME] | West | 7957 | 7957 | 5263
2020 | Restore | [NAME] | West | 5914 | 7957 | 5263
2020 | Spar | [NAME] | Center | 4813 | 7957 | 5263
2020 | Spar | [NAME] | Center | 4867 | 7957 | 5263
2020 | Metro | [NAME] | Center | 5263 | 7957 | 5263
2020 | Restore | [NAME] | West | 8959 | 7957 | 5263
2020 | Auchan | [NAME] | Norh-West | 5539 | 7957 | 5263
2020 | Restore | [NAME] | West | 9863 | 7957 | 5263
2020 | Auchan | [NAME] | Norh-West | 5510 | 7957 | 5263
2020 | Metro | [NAME] | Center | 6272 | 7957 | 5263
2021 | Spar | [NAME] | Center | 7189 | 7957 | 5263
2021 | Metro | [NAME] | Center | 4895 | 7957 | 5263
2021 | Spar | [NAME] | Center | 8221 | 7957 | 5263
2021 | Restore | [NAME] | West | 8471 | 7957 | 5263
2021 | Restore | [NAME] | West | 6350 | 7957 | 5263
2021 | Auchan | [NAME] | Norh-West | 5888 | 7957 | 5263
2021 | Spar | [NAME] | Center | 4558 | 7957 | 5263
2021 | Restore | [NAME] | West | 9253 | 7957 | 5263
2021 | Restore | [NAME] | West | 8367 | 7957 | 5263
2021 | Metro | [NAME] | Center | 9498 | 7957 | 5263
2021 | Metro | [NAME] | Center | 8499 | 7957 | 5263
2021 | Metro | [NAME] | Center | 3880 | 7957 | 5263
2021 | Restore | [NAME] | West | 6888 | 7957 | 5263
2021 | Auchan | [NAME] | Norh-West | 5465 | 7957 | 5263
2021 | Spar | [NAME] | Center | 5749 | 7957 | 5263
Spreadsheet: 210347d1359449202-random-word-generator-for-learning-japanese-traning
Sheet: Sheet1

car | くるま | [NAME]
book | ほん | hon
ship | ふね | fune
paper | かみ | kami
dog | えぬ | enu
cat | ねこ | neko
water | みず | mizu |  | mizu | TRY AGAIN
dinner | ごはん | gohan
morning | あさ | asa
hi | こんにちわ | konnichiwa
Spreadsheet: 33948d1230911426-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: Forfeit

 | Participant |  | Allocation as% of Comp. | Forfeiture Allocation
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 | Totals
 | Accounted for |  |  | 0
 | [NAME]
Spreadsheet: 40b8d465-98a7-421b-ac7f-4dff3d1c77c9
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
TRYPI | Test | TRYPI | Tyrophagus putrescentiae, IgE | Tyrophagus Putrescentiae, 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. | 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
TRYPI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TRYPI | Result | TRYPI | Tyrophagus Putrescentiae, IgE | Tyrophagus Putrescentiae, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6256-2
Spreadsheet: 809909d1671432098-summarise-multiple-excel-worksheets-into-one-sheet-book1
Sheet: Raw Data 1

ID | Surname | First Name | Job | Q1 | Q2 | Q3 | Q4
2931 | Wick | [NAME] | Tax | 74 | 85 | 96 | 96
1591 | [NAME] | [NAME] | Tax | 50 | 15 | 55 | 5
1289 | [NAME] | [NAME] | Legal | 95 | 97 | 32 | 99
2147 | Wo | [NAME] | Legal | 90 | 75 | 61 | 74
Spreadsheet: 674569d1587916641-populating-a-straight-line-depreciation-annual-table-expense-schedule-simple-sl-depreciation-schedule
Sheet: Sheet1

Simple Straight Line Depreciation Schedule
Account: | Home Improvement's
Purchase Date | Item Desc. | Cost | Yr.'s Service | End Date | Salvage Value | Net SL Depreciation | Days of Service | Daily Charge | 1st Year Deprc | [NAME]. Deprc |  | Year | AC Unit | Solar System | Home Remodel | Fence Replacement | Total
2018-03-24 00:00:00 | AC Unit | 10640 | 15 |  | 0 |  |  |  |  |  |  |  | 547.63
2019-07-10 00:00:00 | Solar System | 29408.4 | 20 |  | 0 |  |  |  |  |  |  |  | 709.509 | 400.49 | 343.22 | 173.65
2019-07-25 00:00:00 | Home Remodel | 7885.51 | 10 |  | 0 |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
2020-04-22 00:00:00 | Fence Replacement | 3760 | 15 |  | 0 |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 788.863 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 | 442.52 | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 |  | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 |  | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 709.509 | 1486.474 |  | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  | 159.24 | 1486.474 |  | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1486.474 |  | 234.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1486.474 |  | 76.19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1486.474
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1486.474
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1486.474
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 764.9
Spreadsheet: 703467d1605011609-can-sumif-be-stopped-after-a-unique-value-is-recognized-help-with-excel
Sheet: Sheet1

Unique "Text" | Unique "Number" | Line Item | TOTALS | Details
S | 1 |  | 30 | < need formual that sums down from ROW 5 to ROW 20 but will stop at ROW 8 (either based on Coulmn A having an "S" OR Column B being a value higher than 1
blank |  | Line Items 1 | 10
blank |  | Line Items 2 | 10
blank |  | Line Items 3 | 0
blank |  | Line Items 4 | 10
S | 2 |  | 40 | < need formual that sums down from ROW 10 to ROW 20 but will stop at ROW 15 (either based on Coulmn A having an "S" OR Column B being a value higher than 1
blank |  | Line Items 5 | 20
blank |  | Line Items 6 | 20
blank |  | Line Items 7 | 0
blank |  | Line Items 8 | 0
blank |  | Line Items 9 | 0
blank |  | Line Items 10 | 0
S | 3 |  | 60 | < need formual that sums down from ROW 17 to ROW 20 but will stop at ROW 19 (either based on Coulmn A having an "S" OR Column B being a value higher than 1
blank |  | Line Items 11 | 0
blank |  | Line Items 12 | 30
blank |  | Line Items 13 | 30
S | 4
Spreadsheet: 783494d1654866780-non-array-to-turn-vertical-text-values-to-horizontal-if-condition-is-met-sample
Sheet: Sheet1

Name | Company |  | Name | Company-1 | Company-2 | Company-3 | Company-4 | Company-5 | Company-6 | Company-7 | Company-8 | Company-9 | Company-10
[NAME],Haib | Inform Corp |  | [NAME],Haib | Inform Corp | Dodo, Inc.
[NAME],Haib | Dodo, Inc. |  | Abbou,[NAME] | ERR Corp | Culver Co | Hart Corp
Abbou,[NAME] | ERR Corp |  | Abdal,[NAME] | Kokola Co | TataJX, Inc.
Abbou,[NAME] | Culver Co |  | Abdoo,Chard | Bonak Corp | Mars Corp | Niikolo, Inc. | Foods Corp | Eni Corp
Abbou,[NAME] | Hart Corp
Abdal,[NAME] | Kokola Co
Abdal,[NAME] | TataJX, Inc.
Abdoo,Chard | Bonak Corp
Abdoo,Chard | Mars Corp
Abdoo,Chard | Niikolo, Inc.
Abdoo,Chard | Foods Corp
Abdoo,Chard | Eni Corp
Spreadsheet: 729463d1619101893-calculating-lag-dates-between-dates-lagdate-1-
Sheet: Sheet1

Filed | First Date out |  | Expected Answer |  | Lag Days
2021-01-01 00:00:00 | 2021-03-10 00:00:00 |  | 43
2021-02-10 00:00:00 | 2021-03-27 00:00:00 |  | 26
2021-02-10 00:00:00 | 2021-01-07 00:00:00 |  | 71
2021-01-05 00:00:00 | 2021-02-16 00:00:00 |  | 65
2021-02-23 00:00:00 | 2021-04-10 00:00:00 |  | 12
2021-02-05 | 2021-01-29
2021-02-05 | 2021-01-29
2021-03-15 | 2021-05-07
2021-03-15 | 2021-05-07
2021-03-15 | 2021-05-07
2021-03-15 | 2021-05-07
2021-03-15 | 2021-05-07
Spreadsheet: 469484d1467939495-hard-powerpivot-question-about-unique-sums-booooom
Sheet: Sheet1

 |  |  | Customer | Amount | Status
 |  |  | 1 | 10 | Paid
 |  |  | 1 | 5 | No
 |  |  | 1 | 3 | IDK |  |  | # of customers with paid status | 3
 |  |  | 2 |  | IDK |  |  | Average Amount of Customers WITH paid status | 9
 |  |  | 2 | 5 | Paid
 |  |  | 2 | 5 | Paid
 |  |  | 3 | 6 | Cancelled
 |  |  | 3 | 7 | Cancelled
 |  |  | 4 | 3 | Paid
 |  |  | 4 | 4 | Paid
 |  | Row Labels | Calculated Field 1
 |  | 1 | 10
 |  | 2 | 10
 |  | 4 | 7
 |  | Grand Total | 27
Spreadsheet: 45686d1244501272-auto-totaling-as-long-as
Sheet: Sheet1

PO Number | Open/Closed | PO Amount |  |  |  |  |  | PO Lists | Amouts
1 |  | 3200.77392578125 |  |  |  |  |  | 1 | 32.5
2 |  | 4801.160888671875 |  |  |  |  |  | 2 | 48.75
3 |  | 15201.74133300781 |  |  |  |  |  | 3 | 73.125
4 |  | 10802.61199951172 |  |  |  |  |  | 4 | 109.6875
5 |  | 4010.67138671875 |  |  |  |  |  | 5 | 164.53125
6 |  | 20 |  |  |  |  |  | 1 | 246.796875
 |  |  |  |  |  |  |  | 2 | 370.1953125
 |  |  |  |  |  |  |  | 3 | 555.29296875
 |  |  |  |  |  |  |  | 4 | 832.939453125
 |  |  |  |  |  |  |  | 5 | 1249.4091796875
 |  |  |  |  |  |  |  | 1 | 1874.11376953125
 |  |  |  |  |  |  |  | 2 | 2811.170654296875
 |  |  |  |  |  |  |  | 3 | 4216.755981445312
 |  |  |  |  |  |  |  | 4 | 6325.133972167969
 |  |  |  |  |  |  |  | 5 | 32.5
 |  |  |  |  |  |  |  | 1 | 48.75
 |  |  |  |  |  |  |  | 2 | 73.125
 |  |  |  |  |  |  |  | 3 | 109.6875
 |  |  |  |  |  |  |  | 4 | 164.53125
 |  |  |  |  |  |  |  | 5 | 246.796875
 |  |  |  |  |  |  |  | 1 | 370.1953125
 |  |  |  |  |  |  |  | 2 | 555.29296875
 |  |  |  |  |  |  |  | 3 | 832.939453125
 |  |  |  |  |  |  |  | 4 | 1249.4091796875
 |  |  |  |  |  |  |  | 5 | 1874.11376953125
 |  |  |  |  |  |  |  | 1 | 73.125
 |  |  |  |  |  |  |  | 2 | 109.6875
 |  |  |  |  |  |  |  | 3 | 164.53125
 |  |  |  |  |  |  |  | 4 | 246.796875
 |  |  |  |  |  |  |  | 5 | 370.1953125
 |  |  |  |  |  |  |  | 1 | 555.29296875
 |  |  |  |  |  |  |  | 2 | 832.939453125
 |  |  |  |  |  |  |  | 3 | 1249.4091796875
 |  |  |  |  |  |  |  | 4 | 1874.11376953125
 |  |  |  |  |  |  |  | 5 | 73.125
Total PO's for Project |  | 38036.95953369141 |  |  |  |  |  | 6 | 20
Total Open PO's |  | 0 |  |  |  |  |  | 3 | 8000
Spreadsheet: 3be1f847-08fe-4002-95a2-e1efdc5cc7fa
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
GRNMS | Test | GRNMS | [NAME] (GRN), Full Gene Analysis | [NAME] | Polymerase Chain Reaction (PCR)/DNA Sequencing Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:  1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday, 10:00 a.m. | 14 days | 20 days | 1 | 81479 |  |  |  |  | Rochester
GRNMS | [NAME] | VARIES | Varies |  |  |  | Ambient
GRNMS | Result | 29651 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
GRNMS | Result | 29652 | [NAME] | [NAME] | Alphanumeric
GRNMS | Result | 29653 | Source | Source | Alphanumeric
GRNMS | Result | 29654 | Order Date | Order Date | Alphanumeric
GRNMS | Result | 29655 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
GRNMS | Result | 29656 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GRNMS | Result | 29657 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GRNMS | Result | 29658 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
GRNMS | Result | 29388 | Extraction Performed? | Extraction Performed? | Alphanumeric
GRNMS | Result | 29659 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GRNMS | Result | 29660 | Reviewed By: | Reviewed By: | Alphanumeric
GRNMS | Result | 29661 | Release Date | Release Date | Alphanumeric
Spreadsheet: 71824d1272535477-if-and-vlookup-not-doing-as-i-want-emac-and-kerridge-checker
Sheet: From Kerridge

A2ABK | Mr A Kirbell
BF08LSN | Mr J Corbridge
BN05NPV | Mr S Whitehead
FD55ODJ | Dr R Mantin
FE58ZYJ | Mr M Bloom
FV55YPE | Miss H Mealing
GJ57EYA | Mr [NAME]
GL03XKK | Mrs E Ashton
GP07RWN | [NAME]
GP07XBJ | Mrs J Barnes
[NAME] | Mr D Slough
GP08BZS | Mrs P Botterill
GP08BZX | Miss R Khanam-Ali
GP08GVJ | Mr T Skelton
GP08GVK | Mr C Eyles
[NAME] | Mrs C Brooker
GP08MUV | Ms P Budd
GP08MVC | Mrs S Young
GP08MVE | Mrs C Redman
GP08WTA | Mr A Hawkins
GP08WTJ | Miss [NAME]
GP57HFC | Miss C Halsey
GP57HFE | [NAME]
GP57HFF | Mrs C Hills
GR07BYJ | Mr B Jordan
GR07WPT | Mr J Torr
GR57ANV | Mr D Andrews
GR57CFZ | [NAME]
[NAME] | Miss G Crowhurst
GU05KRX | [NAME]
GU07UCA | Mr I [NAME]
[NAME] | Miss M Jacobs
GU07ZKG | Mrs J Keig-Shevlin
GU08GZW | [NAME]
GU08HBC | [NAME] Freese
GU08HBJ | Miss J Stocks
GU08XBK | Mr D Chitty
GU09UWW | Mr M Welch
GU09UXB | Mr S Sheasby
GU09UXE | Miss D Figg
GU09UXL | [NAME]
GU09UXM | Mr G [NAME]
GU09UXT | Mr [NAME]
GU09UXX | Mr C Coulson
GU09XRY | Mr S Knight
GU09YJJ | Mrs J Culver
GU56HGG | Mr R Woodley
GU57LNE | Mr A Marriott
GU57LNR | Mrs J Railton
GU57LOJ | Mr J Lowe
GU57YML | Mrs E Parker
GU58LFX | Mr S Mann
GU58LGC | Mr D Cox
GU58LGE | Ms L P Ellis
GU58LGF | Mrs C [NAME]
GU58LGG | Miss [NAME]
GU58LGJ | Mrs J Tester
GU58LGO | Mr A [NAME]
GU58LGY | Miss A [NAME]
GU58XVM | Mr T C Mansell
GV06WDG | [NAME]
GV07ZVE | Mrs S M Beardsley
GV55ETU | Mr A Bonetti
GV55NVJ | Mr M Boardman
GV57SJU | Miss S Suttle
GV57TCJ | Mrs J Tuffill
GV58GXT | Miss V Kennard
GV58UFB | [NAME]
GX08HRL | Mr [NAME]
GY04JZF | Mr G Jordan
GY06GFU | [NAME]
GY06GGK | Mr [NAME]
GY07PVE | Mrs C [NAME]
GY08MHE | [NAME]
GY08OBP | Mr P Lewis
GY08UJV | Mrs J Smyth
GY08VKZ | Miss V Tibbles
GY09FXL | [NAME]
GY09FXO | [NAME]
GY09FXT | [NAME]
GY09FXU | Mr P Murphy
GY09FXW | [NAME]
GY09OPP | Mr S Humphrey
GY09OPS | Mr S Humphrey
GY09WHN | Mrs J B Hyam
GY09WHS | Miss A Smith
GY09WHW | Mr W Rice
GY09WJD | Mr D Divall
GY55UNB | Ms P Kelly
GY55VLW | Mr D Baillie
GY57YCB | Miss G Harris
GY58FVT | Mrs J Tingay
GY58GBV | Mrs G Horspool
GY58LCO | Mrs J [NAME]
GY58RKN | Mr [NAME]
GY58SWF | Mr P Banks
GY58SWK | Mr R Slimming
GY58SWW | Mr C Walker
GY58SXE | Mr A Mott
GY58SXF | Mr M Ferguson
[NAME] | [NAME]
GY58XOW | Mrs J Nurse
GY59CSZ | Paint Tech
HK06EET | Mr S Railton
HN05VJO | [NAME]
HY57XPR | Mr E White
J2JYO | [NAME]
J6CAS | Miss C Myler
KM08WBY | [NAME]
[NAME] | Mr C [NAME]
KO08CXT | Ms L Corcoran
KP03HFC | Mr B Le Grove
KP56WJU | Mr J [NAME]
KR06HSV | Miss [NAME]
[NAME] | Mr J [NAME]
KS08TEV | Miss I [NAME]
KS55ODK | Mr S Baron
KV06CVD | Mrs P Twine
KV57WLF | Miss O Carver
KW07AYU | Mr J Rainbird
KW56TCV | Mr I Tebbitt
KY57LNO | Mr E B Hurst
KY57PYZ | Canon A R Chanter
LC05WMG | Mr G Till
LW51MAW | Mr [NAME]
MD53EZR | Mrs J Proctor
MK57HZF | Mrs D Thompson
ML07BLV | Mr R Spriggs
NC53NHM | Mr [NAME]
ND06WZO | Mr [NAME]
PK55SZJ | Mr Pettican
R20BDB | [NAME]
RK06YJT | [NAME]
S77VJM | [NAME]
VN08EFB | Mrs A [NAME]
W37PGH | Mr M Nicholls
WF06EYV | Mr P Merritt
WN55WNL | Mr D Ibbitson
X485OAC | Mrs Treby
[NAME] | Mr D Lester
Spreadsheet: 744520d1629283884-copy-cell-if-value-is-less-than-6-orderiindexand-aggregate
Sheet: Order Form

Barcode | Description | Remaining
Spreadsheet: benjamin_rogers__1245__test model from Erin
Sheet: TAXES-ENA

INCOME TAXES
EBTDA
Tax Depreciation
Earnings Before Taxes
VA State Income Taxes
Earnings After State Taxes
NOL Carryforward
Beginning Balance of NOL |  | 0
Additions
NOL Carryforwards Used
Ending Bal of NOL Carryforwards
Taxable Income
Tax Rate Determination:
Net Tax Rate
Adjusted Taxable Income
Tax Liability Before Credits
Income Taxes Paid (Not including Property Tax)
Spreadsheet: 463081d1464288184-calculation-of-downtime-with-a-range-of-time-for-various-status-copy-of-down
Sheet: Sheet1

 |  | Count | Downtime
 | Pending
 | Rejected
 | Resolved
 | Closed
 | In Progress
 | Total
 | Downtime
 | SLA | Closed | Rejected | Resolved | Pending | In Progress | Total
0 | Within 4 Hours
4 | Within 8 Hours
8 | Within 24 Hours
24 | Greater Than 24
 | Total
 | Count
 | SLA | Closed | Rejected | Resolved | Pending | In Progress | Total
 | Within 4 Hours
 | Within 8 Hours
 | Within 24 Hours
 | Greater Than 24
 | Total
Spreadsheet: 719835d1613842592-amortisation-schedule-with-varying-periods-and-varying-interest-rates-amortisation-table
Sheet: Sheet1

 |  | Existing Period for formula |  |  | 7
 |  | Interest Rate |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 |  | Opening Balance |  | 1 | 1
 |  | interest for period
 |  | principal for period
 |  | payment for period
 |  | Closing Balance
 |  | Period Wanted for formula |  |  | 0.42 | 1 | 1 | 1 | 1 | 1 | 0.58 |  | period is a proportion of a year using YEARFRAC
 |  | Interest Rate |  |  | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.1 | 0.09 |  | interest rate must be variable
 |  | Opening Balance |  | 1 | 1
 |  | interest for period
 |  | principal for period
 |  | payment for period
 |  | Closing Balance
Spreadsheet: 469117d1467781015-is-it-possible-to-auto-fill-a-column-of-cells-dependent-the-rows-in-another-column-example
Sheet: After

Imporeted Data Type | Value | Formula 1 |  | Formula 2
Imported Data 1 | 1
Imported Data 2 | 2
Imported Data 3 | 3
Imported Data 4 | 4
Imported Data 5 | 5
Imported Data 6 | 6
Imported Data 7 | 7
Imported Data 8 | 8