tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 05543fb0-0976-47f9-b572-b6a217844e7f
Sheet: Entries

Entries to record property taxes
Jan 1 | Debit | GL 110 | Current Taxes Receivable
 | Credit | GL 235 | Deferred Revenue
 |  | To record current year levy as taxes receivable
Jan 1 | Debit | GL 111 | Delinquent Taxes Receivable
 | Credit | GL 110 | Current Taxes Receivable
 |  | To transfer current taxes receivable to delinquent taxes
Jan - July | Debit | GL 101 | Cash
 | Credit | GL 110 | Current Taxes Receivable
 | Credit | GL 111 | Delinquent Taxes Receivable
 | Credit | SRC 009 | Fiscal Disparities
 | Credit | SRC 014 | Taconite Homestead Credit
 | Credit | SRC 019 | Miscellaneous tax revenue
 |  | To record first half tax settlements received from counties
June 30 | Debit | GL 235 | Deferred Revenue
 | Debit | GL 214 | Advance of Unearned Gened
 | Credit | SRC 001 | Tax Revenue
 | Credit | SRC 211 | Tax Revenue (Portions with Finance Codes)
 |  | To record current year tax shift
 | Note:  Property tax shift entry shown on "Report" tab combines the June 30th entry to record the current year tax shift (entry just above this note) with the prior July 1st entry to reverse the prior year tax shift (entry similar to entry below, but for the previous July 1st).
July 1 | Debit | SRC 001 | Tax Revenue
 | Debit | SRC 211 | Tax Revenue (Portions with Finance Codes)
 | Credit | GL 235 | Deferred Revenue
 | Debit | GL 214 | Advance of Unearned Gened
 |  | To reverse prior year tax shift
July 1 | Debit | GL 235 | Deferred Revenue
 | Credit | SRC 001 | Tax Revenue
 | Credit | SRC 001 | Tax Revenue (Portions with Finance Codes)
 |  | To record levy revenue for current year
July 1 | Debit | SRC 001 | Tax Revenue
 | Credit | GL 110 | Current Taxes Receivable
 |  | To reduce taxes receivable for amount to be paid by state credits
July 1 | Debit | SRC 001 | Tax Revenue
 | Credit | GL 110 | Current Taxes Receivable
 |  | To reduce taxes receivable for amount to be paid by fiscal disparities
July 1 | Debit | SRC 001 | Tax Revenue
 | Credit | GL 110 | Current Taxes Receivable
 |  | To reduce taxes receivable for amount to be paid by taconite homestead credit
July 1 | Debit/Credit | SRC 001 | Tax Revenue
 | Credit/Debit | GL 110 | Current Taxes Receivable
 |  | To adjust taxes receivable for county auditor adjustments
Oct - Jan | Debit | GL 101 | Cash
 | Credit | GL 110 | Current Taxes Receivable
 | Credit | GL 111 | Delinquent Taxes Receivable
 | Credit | GL 009 | Fiscal Disparities
 | Credit | GL 014 | Taconite Homestead Credit
 | Credit | SRC 019 | Miscellaneous tax revenue
 |  | To record second half tax settlements received from counties
June 30 | Debit | SRC 001 | Tax Revenue
 | Credit | GL 111 | Delinquent Taxes Receivable
 |  | To reduce taxes receivable for abatements
June 30 | Debit | SRC 001 | Tax Revenue
 | Credit | GL 111 | Delinquent Taxes Receivable
 |  | To reduce taxes receivable for seventh-year write offs
June 30 | Debit/Credit | SRC 001 | Tax Revenue
 | Credit/Debit | GL 231 | Deferred Revenue--Delinquent Taxes
 |  | To adjust deferred revenue for delinquent taxes
Spreadsheet: 141959d1329539032-help-with-changing-format-into-time-and-averaging-book2
Sheet: Sheet1

 |  |  | Processed |  | In store |  | Average time
Before 9am | Number | Weight | DATE | TIME | DATE | TIME
 | 1 | 194 | 2011-10-13 00:00:00 | 5.23am | 2011-10-13 00:00:00 | 8.18am
 | 1 | 194 | 2011-10-13 00:00:00 | 5.18am | 2011-10-13 00:00:00 | 8.18am
 | 1 | 626.5 | 2011-10-13 00:00:00 | 5.19am | 2011-10-13 00:00:00 | 8.19am
 | 2 | 1602 | 2011-10-27 00:00:00 | 5.35am | 2011-10-27 00:00:00 | 8.59am
Before 11am
 | 2 | 7393 | 2011-10-25 00:00:00 | 5.34am | 2011-10-25 00:00:00 | 10.10am
 | 2 | 1090 | 2011-10-14 00:00:00 | 5.12am | 2011-10-14 00:00:00 | 10.50am
 | 2 | 7143 | 2011-10-18 00:00:00 | 5.25am | 2011-10-18 00:00:00 | 9.28am
 | 1 | 1692 | 2011-10-31 00:00:00 | 6.05am | 2011-10-31 00:00:00 | 9.39am
 | 1 | 1412 | 2011-10-21 00:00:00 | 5.20am | 2011-10-21 00:00:00 | 9.41am
Midday onwards
 | 2 | 1586.5 | 2011-10-31 00:00:00 | 6.01am | 2011-10-31 00:00:00 | 11.48am
 | 1 | 3716 | 2011-10-26 00:00:00 | 5.24am | 2011-10-26 00:00:00 | 1.46pm
 | 1 | 3716 | 2011-10-26 00:00:00 | 5.11am | 2011-10-26 00:00:00 | 1.46pm
 | 2 | 7230 | 2011-10-26 00:00:00 | 5.11am | 2011-10-26 00:00:00 | 1.46pm
 | 2 | 2384.7 | 2011-10-17 00:00:00 | 9.26am | 2011-10-17 00:00:00 | 2.02pm
 | 50 | 914 | 2011-10-17 00:00:00 | 5.51am | 2011-10-17 00:00:00 | 2.08pm
 | 50 | 914 | 2011-10-17 00:00:00 | 9.45am | 2011-10-17 00:00:00 | 2.08pm
 | 1 | 1778 | 2011-10-17 00:00:00 | 5.52am | 2011-10-17 00:00:00 | 2.09pm
 | 165 | 3465 | 2011-10-19 00:00:00 | 5.35am | 2011-10-19 00:00:00 | 2.58pm
Overnight
 | 1 | 3918 | 2011-10-25 00:00:00 | 5.32am | 2011-10-26 00:00:00 | 1.46pm
 | 1 | 582 | 2011-10-19 00:00:00 | 5.34am | 2011-10-20 00:00:00 | 10.00am
 | 3 | 3638.5 | 2011-10-29 00:00:00 | 6.59am | 2011-10-31 00:00:00 | 8.17am
 | 1 | 1798 | 2011-10-24 00:00:00 | 5.12am | 2011-10-25 00:00:00 | 8.48am
 | 1 | 2071 | 2011-10-24 00:00:00 | 5.03am | 2011-10-25 00:00:00 | 8.52am
 | 1 | 3700 | 2011-10-15 00:00:00 | 7.10am | 2011-10-17 00:00:00 | 9.02am
 | 2 | 5550 | 2011-10-14 00:00:00 | 5.14am | 2011-10-17 00:00:00 | 9.02am
Spreadsheet: 769811d1645698965-looking-for-help-on-graphically-showing-proportions-weighting-issue-weighted-avg
Sheet: Sheet1

 |  |  | Q1 '21 Target | 0.8799999999999978 | Units |  | Units % | Gap %
 |  |  | Product A | -0.01692223198679977 | 439
 |  |  | Product B | 0.002045207892753737 | 9
 |  |  | Product C | -0.00997207758372228 | 16 |  |  |  | This is the problem - the gap of 32% is contributed by 3% of units
 |  |  | Product D | -0.005979919462883605 | 60
 |  |  | Q1 '21 Actual | 0.8491709788593549
Spreadsheet: 5647b579-e3fd-41e5-8b03-00224dbf8408
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
NMOCC | Test | NMOCC | Neuromyelitis Optica (NMO)/Aquaporin-4-IgG Cell-Binding Assay, CSF | NMO/AQP4-IgG CBA, CSF | Cell-binding assay (CBA) detects IgG specific for [NAME] (M1 isoform) by indirect immunofluorescence (IFA) | Plastic vial: PlV |  |  | 1 | mL | Collection Container/Tube: Sterile vial [NAME]: 1 mL Additional Information: Include relevant clinical information, name, phone number, mailing address, and e-mail address (if applicable) of ordering physician. | 0.5 mL | Hemolysis	Mild OK; Gross reject  Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild reject; Gross reject Other	NA | Negative | Monday through Friday; 8 a.m. | Negative: 2 days; Positive: 3 days | 6 days | 1 | 86255 |  |  |  |  | Rochester
NMOCC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 28 days
NMOCC | Result | 61716 | NMO/AQP4-IgG CBA, CSF | NMO/AQP4-IgG CBA, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 71414d1272102018-conditional-sum-on-filtered-column-cond-sum-filtered-cells
Sheet: Sheet1

curency | amount | 20 | usd
usd | 1
eur | 2
usd | 4
eur | 4
usd | 5
eur | 1
usd | 2
eur | 6
usd | 7
eur | 5
usd | 8
eur | 2
usd | 3
eur | 4
usd | 9
eur | 1
usd | 9
eur | 3
usd | 4
Spreadsheet: 846620d1697759188-automatic-date-formula-dagang-tas-eiger-tahap-3-ririn0105-
Sheet: Stock

Stock
No | Items | Color | Quantity | Sold | Balance
1 | Eiger Starter Daypack 16L | Blue
2 | Eiger Starter Daypack 16L | Olive
3 | [NAME] Backpack 20L | Black
4 | [NAME] Backpack 20L | Navy
5 | [NAME] Backpack 20L | Khaki
6 | Eiger Meridian 30L Laptop Backpack | Black
7 | [NAME] 15 Laptop Backpack | Navy
8 | [NAME] 15 Laptop Backpack | Black
9 | [NAME] Pack 20L Backpack | Navy
10 | [NAME] Pack 20L Backpack | Green
11 | [NAME] Pack 20L Backpack | Black
12 | [NAME] | Navy
13 | [NAME] | Olive
14 | [NAME] 3.0 Laptop 18L Backpack | Black
15 | [NAME] 3.0 Laptop 18L Backpack | Olive
16 | [NAME] 2.0 Laptop Backpack 20L | Black
17 | [NAME] Termina 2.0 Backpack | Navy
18 | [NAME] Termina 2.0 Backpack | Black
19 | [NAME] 20L Woman Backpack | Burgundy
20 | [NAME] 20L Woman Backpack | [NAME]
21 | [NAME] 20L Woman Backpack | [NAME]
22 | Eiger Meridian 30L Laptop Backpack | [NAME]
23 | Eiger Starter Daypack 21L | Olive
24 | Eiger Starter Daypack 21L | Blue
25 | [NAME] 25L | Black
26 | [NAME] 25L | Navy
27 | [NAME] 25L | Khaki
28 | Eiger Forlough 20 Laptop Backpack | Black
29 | Eiger Forlough 20 Laptop Backpack | Maroon
30 | [NAME] 20L Laptop Backpack | Navy
Spreadsheet: chris_germany__1849__GasPurchaseAgreementExhibit2
Sheet: Sheet1

EXHIBIT "2"  INJECTION & WITHDRAWAL SCHEDULE AS % OF STORAGE CAPACITY
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00
Atlanta  (CNG)
Injection
Withdrawal | 0.2492 | 0.032 | 0.0479 |  |  |  |  |  |  |  | 0.1917 | 0.4793 | 0.2492 | 0.032 | 0.0479
Atlanta  (Sonat)
Injection
Withdrawal | 0.3156 | 0.1207 | 0.0877 | 0.0577 | 0.0255 |  |  |  | 0.0116 | 0.0579 | 0.0508 | 0.2726 | 0.3156 | 0.1207 | 0.0877
Atlanta  (Tennessee-FS MA)
Injection
Withdrawal | 0.2393 | 0.2162 | 0.1431 |  |  |  |  |  |  |  | 0.1621 | 0.2393 | 0.2393 | 0.2162 | 0.1431
Atlanta  (Tennessee-FS PA)
Injection
Withdrawal | 0.2144 | 0.1937 | 0.1697 | 0.0209 | 0.007 |  |  |  |  |  | 0.1798 | 0.2144 | 0.2144 | 0.1937 | 0.1697
Atlanta  (Transco-ESS)
Injection
Withdrawal | 0.9192 |  |  |  |  |  |  |  |  |  |  | 0.0808 | 0.9192
Atlanta  (Transco-WSS)
Injection
Withdrawal | 0.2526 | 0.1829 | 0.1159 | 0.0221 |  |  |  |  |  |  | 0.1249 | 0.3017 | 0.2526 | 0.1829 | 0.1159
BG & E  (TCO & CNG)
Injection |  |  |  | 0.15 | 0.2 | 0.2 | 0.2 | 0.1 | 0.13 | 0.02
Withdrawal | 0.49 | 0.18 | 0.2 |  |  |  |  |  |  |  | 0 | 0.13 | 0.49 | 0.18 | 0.2
COH  (TCO)
Injection |  |  |  | 0.15 | 0.2 | 0.2 | 0.2 | 0.1 | 0.13 | 0.02
Withdrawal | 0.25 | 0.25 | 0.15 |  |  |  |  |  |  |  | 0.15 | 0.25 | 0.25 | 0.2 | 0.15
NIPSCO  (Egan & Moss Bluff)
Injection |  |  |  | 0.3 | 0.31 | 0.3 | 0.09
Withdrawal | 0.1 | 0.29 | 0.2 | 0.1 |  |  |  |  |  |  | 0.1 | 0.3 | 0.3 | 0.2 | 0.1
Spreadsheet: 101457d1299589593-help-needed-for-advanced-transposing-transpose
Sheet: output

no1 | grp1 | tech1 | business1 | 2011-01-01 00:00:00 | 1
no1 | grp1 | tech1 | business1 | 2011-02-01 00:00:00 | 2
no1 | grp1 | tech1 | business1 | 2011-03-01 00:00:00 | 3
[NAME] | grp1 | tech2 | business1 | 2011-01-01 00:00:00 | 4
[NAME] | grp1 | tech2 | business1 | 2011-02-01 00:00:00 | 5
[NAME] | grp1 | tech2 | business1 | 2011-03-01 00:00:00 | 6
no3 | [NAME] | tech1 | [NAME] | 2011-01-01 00:00:00 | 7
no3 | [NAME] | tech1 | [NAME] | 2011-02-01 00:00:00 | 8
no3 | [NAME] | tech1 | [NAME] | 2011-03-01 00:00:00 | 9
no4 | grp3 | tech1 | business1 | 2011-01-01 00:00:00 | 10
no4 | grp3 | tech1 | business1 | 2011-02-01 00:00:00 | 11
no4 | grp3 | tech1 | business1 | 2011-03-01 00:00:00 | 12
no5 | grp4 | [NAME] | [NAME] | 2011-01-01 00:00:00 | 13
no5 | grp4 | [NAME] | [NAME] | 2011-02-01 00:00:00 | 14
no5 | grp4 | [NAME] | [NAME] | 2011-03-01 00:00:00 | 15
Spreadsheet: 100314d1298675892-rank-data-without-duplicates-grouping
Sheet: Sheet1

Agreement ID | Supplier | Spend
A123 | ABC | 50
A234 | ABC | 20
A345 | ABC | 9
A456 | XYZ | 101
A567 | CDE | 68
A678 | CDE | 90
A789 | GHI | 800 |  | Below is a Pivot Table Answer - No Formulas
How to get to a table like this: |  |  |  | Sum of Spend
 | Top Suppliers: | Spend |  | Supplier | Total
1 | GHI | 800 |  | GHI | 800
2 | CDE | 158 |  | CDE | 158
3 | XYZ | 101 |  | XYZ | 101
4 | ABC | 79 |  | ABC | 79
 |  |  |  | Grand Total | 1138
Spreadsheet: 149372d1333890721-if-cells-in-column-match-merge-other-cells-together-cp49321_tool-search_07apr12_02
Sheet: Sheet2

Gage ID | Description | Gage S/N | Type | Notes | Current Location | Last Cal Date | Next Due Date | Database
Spreadsheet: 166641d1341678603-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped-mick86_843222-using-mod-row-to-display-in-every-nth-cell-with-some-cells-skipped_07jul12_01
Sheet: Daily

Item # |  |  |  |  |  |  |  |  |  |  | < Example does not manage to repeat properly over gaps
1 |  |  |  |  |  |  |  |  |  |  | Repeat frequencys come from setup sheet
Total mg's |  |  |  |  |  |  |  |  |  |  | reference
Friday |  |  | 1 |  |  | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  | 1 |  | < Attempt using count of 3 in blocks of 7 with 4 row gaps
Saturday
Sunday
Monday |  |  |  |  |  |  |  |  |  |  | 2
Tuesday
Wednesday
Thursday |  |  |  |  |  |  |  |  |  |  | 3
Item #
2
Total mg's
Friday
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < this number should b 1 ro lower as per the repeat of 1 value 2 blank rows
Sunday |  |  |  |  |  |  |  |  |  |  | 4
Monday
Tuesday
Wednesday |  |  |  |  |  |  |  |  |  |  | 5
Thursday
Item #
Total mg's
Friday
Saturday |  |  |  |  |  |  |  |  |  |  | 6
Sunday
Monday
Tuesday |  |  |  |  |  |  |  |  |  |  | 7
Wednesday
Thursday
Spreadsheet: benjamin_rogers__1098__ENA Peaker Plant Summaries
Sheet: Caledonia

 | PLANT LOCATION: |  | Caledonia, MS
 | Pipeline: |  | Tennessee Gas Pipeline
 | Delivery Point: |  | Plant-Gate, Tennessee Zone 1, 500 [NAME] and Portland, TN
 | MW Output: |  | 443 MW
 | Heat Rate: |  | 12013
 | 16 Hour Gas Flow: |  | 85,200 MMBtu/day
 | Facility Costs: |  | $981,000  (ECT Pays)
 | Start Date: |  | June, 1999
 | TRANSPORTATION ARRANGEMENT:
 | Option A (Combination of FT, AO and Backhaul Service)
 |  | [NAME] CONTRACT
 |  | Term: | 10 years (May - Sept)
 |  | Volume: | 85,200 MMBtu/d
 |  | IT CONTRACT
 |  | Rate: | $.1125 plus fuel
 |  | Vol. Commit: | 4.5 Bcf per year
 |  | Receipt Points: | Zone 0 & 1
 |  | FT-A with AO CONTRACT
 |  | Rate: | $.01 year round | Demand on 12,500/d
 |  |  | $.1085 plus fuel | Commodity on first 12,500/d
 |  |  | $.1125 plus fuel | Commodity on excess (up to 72,700 Dth/day)
 |  | Vol. Commit: | 4.5 Bcf per year, [NAME] credited yrs 1,2,3,4 against yrs 5,4
 |  |  | All gas flowing to plant gate meter is credited against volume commitment an
 |  |  | Gas flown to Portland, TN under FT and AO Services
 |  | Fuel: | 0.5% on Backhaul; 1.70% on forward haul
 |  | Receipt Points: | Zone 1 & Zone L
 |  | BACK-UP CONTRACT
 |  | FT-BH CONTRACT (Years 1-5)
 |  | Rate: | $.05 plus fuel (volumetric)
 |  | Receipt Points: | Downstream point in Zone 1, 2, 4, 5 & 6
 | Option B:  ECT has a one time right to convert to Option B
 |  | at any time during the life of the agreement
 |  | FT-A CONTRACT (Plant sole provider)
 |  | Rate: | $.01 year round | Demand on 85,200/d
 |  |  | $.12 plus fuel | Commodity on first 5.0 Bcf/yr
 |  |  | $.05 plus fuel | Commodity on next 1.4 Bcf/yr
 |  | Receipt Points: | 500 [NAME] | Secondary
 |  |  | Midwestern | Primary (Years 1-5)
 |  |  | Midwestern Like | Primary (Years 6-10)
 | BALANCING:
 |  | OBA at plant interconnect @ no cost to Caledonia
 |  | Cash-out monthly, subject to 5% tolerance on monthly receipt volumes
 |  | Allows for uneven hourly flow at plant delivery point with even 24 hour supply flow
 | OTHER: | Cancellation Option beginning at year 6. Payoff as follows:
 |  | YRS 6-10 | 1100000
 |  | YRS 7-10 | 1000000
 |  | YRS 8-10 | 950000
 |  | YRS 9-10 | 900000
 |  | YR 10 | 800000
Spreadsheet: 594693d1539899010-countifs-trouble-test-sheet
Sheet: Sheet1

N/U/C | Sales 1 | Sales 2 |  | JACKS NEW SALES | JACKS USED SALES
NEW | JACK |  |  | 2 | 0.5
NEW | [NAME] | JACK
NEW | JACK
NEW | [NAME] | JACK
USED | JACK | [NAME]
NEW
NEW
NEW
NEW
NEW
USED
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 10

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 6.3
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 9 Jul Glucose mmol/L
Mon 10 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  | 7.1 |  |  |  | 6.8
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 11 Jul Glucose mmol/L
Wed 12 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 13 Jul Glucose mmol/L
Fri 14 Jul Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 15 Jul Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sun 16 Jul Glucose mmol/L
Spreadsheet: 267933d1380296511-need-help-with-an-index-formula-example
Sheet: Sheet1

Location | Part # [NAME] | Part # Running | Readout
A |  | Top | 162.85
B |  | Top | 172.58
A |  | Top | 162.86
B |  | Bottom | 159.3
A |  | Bottom | 92
B |  | Bottom | 162.84
A |  | Top | 101.45
B |  | Top | 101.75
A |  | Top | 92.75
B |  | Bottom | 162.86
A |  | Bottom | 172.59
B |  | Bottom | 162.87
A |  | Top | 159.4
B |  | Top | 93
A |  | Top | 95.75
B |  | Bottom | 163.25
A |  | Bottom | 89.25
B |  | Bottom | 102
Needed Result:
 |  | Highest Reading | Lowest Reading
A
B
Spreadsheet: 785046d1656095958-importing-data-from-one-tab-into-another-test-data
Sheet: Sheet1

AJ011100 | 124 bent street | 4521.12
AJ011101 | 15 hell street | 999.25
AJ011102 | 19 bell street | 145.25
AJ011103 | 8 banana avenue | 1245.02
AJ011104 | 8 great hill | 125.36
AJ011105 | 96 hump hill | 178.36
AJ011106 | 14 hastle drive | 542.36
AJ011107 | 6 millers way | 2.36
Spreadsheet: 96241d1295635985-excel-2007-trying-to-use-data-validation-example-spreadsheet
Sheet: Cost Calculator

BEFORE |  |  |  |  |  |  | AFTER
 | Part# | Style | Size | Color | Price |  |  | Part# | Style | Size | Color | Price
Base cost of shirt |  |  |  |  |  |  | Base cost of shirt | 1001 | Shirt | Size | Red | 3
Labor |  |  |  |  |  |  | Labor |  |  |  |  | 20
Materials |  |  |  |  |  |  | Materials |  |  |  |  | 15
Setup |  |  |  |  |  |  | Setup |  |  |  |  | 25
Quantity |  |  |  |  |  |  | Quantity |  |  |  |  | 20
 |  |  |  | Total |  |  |  |  |  |  | Total
Spreadsheet: 719796d1613820466-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep-update-1-ans
Sheet: Pre

ID | NAME | DATE1 | PT | COMMON |  |  |  |  |  |  | # 1 | # 2 | # 3 | SUM1 | SUM2 | TYPE 2 | ALL PO |  | AR | AF
1226572 |  |  | Post 100% | AAA |  |  |  |  |  |  | 1 |  |  |  |  |  | 249975 |  |  |  | Expected Value: "Pre Calc" | Scenario 2 (1st logic upate)
1226191 |  |  | Net Down | BB of B |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | Expected Value: "Pre Calc" | Scenario 2 (1st logic upate)
1224113 |  |  | Post 100% | FDFDE |  |  |  |  |  |  | 1 |  |  |  |  |  | 21428 |  |  |  | Expected Value: '-' | Scenario 2 (2nd logic update)
1172600 |  |  | Post 100% | EREFE |  |  |  |  |  |  | 1 |  |  |  |  |  | 50039
1163603 |  |  | Net Down | ODJEO |  |  |  |  |  |  | 1 |  |  |  |  |  | 23221891
1179778 |  |  | Post 100% | EREERE |  |  |  |  |  |  | 1 |  |  |  |  |  | 1180674
Spreadsheet: 158144d1338002003-determining-above-or-below-a-result-graph-designs-example-1_solution
Sheet: Sheet1

 |  |  | Survey Results
 |  |  | V01 | 0.82 | 0.86
 |  |  | V02 | 0.827 | 0.86
 |  |  | V03 | 0.907 | 0.86
 |  |  | V04 | 0.955 | 0.86
 |  |  | V05 | 0.868 | 0.86
 |  |  | V06 | 0.833 | 0.86
 |  |  | V07 | 0.857 | 0.86
 |  |  | V08 | 0.864 | 0.86
 |  |  | V09 | 0.958 | 0.86
 |  |  | V10 | 0.813 | 0.86
 |  |  | V11 | 1 | 0.86
Spreadsheet: 213489d1360540296-identify-if-a-number-is-contained-within-40-or-more-number-ranges-phones
Sheet: Sheet1

Site | Start | Range
A1 | 5000 | 5199 |  |  |  | 6500
A2 | 5200 | 5299 |  |  |  | 7200
Outside | 6000 | 6499 |  |  |  | 5250
A3 | 6500 | 6599 |  |  |  | 6005
A4 | 7000 | 7599
A40 | 9600 | 9799
A41 | 9900 | 9899
Spreadsheet: 796605d1663397074-adding-years-and-months-in-decimal-format-2022-09-17-oeldere-goodboy-adding-years-and-months-in-decimal-format-1-
Sheet: Sheet1

1.1 | 2.11 | 4 | Kolom1 | Yellow column is the answer |  |  |  |  |  | 1
3.6 | 14.3 | 17.9 | 4 years |  |  |  |  |  |  | 2
2.5 | 2.8 | 5.1 | 17 years 9 months |  |  |  |  |  |  | 3
 |  |  | 5 years 1 month |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  | 20 |  |  | 4 | years
 |  |  |  |  |  |  |  |  |  | 21 |  |  | 17 | years | 9 | months
 |  |  |  |  |  |  |  |  |  | 22 |  |  | 5 | years | 1 | month
 |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  | 69
Spreadsheet: darrell_schoolcraft__7807__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 | -719904 | -715180 | -27002 | -25000
9 | -725690 | -722897 | -51038 | -50000
10 | -740803 | -742788 | -51972 | -50000
11 | -752259 | -753379 | -124
12 | -743592 | -743981 | -51599 | -50000
13 | -722904 | -722201 | -20107 | -20000
14 | -711618 | -701605
15 | -679140 | -681609
16 | -674938 | -699370 | -25872 | -25000
17 | -694068 | -664964 | -25122 | -25000
18 | -715015 | -718391 | -185
19 | -703637 | -699226 | -24990 | -25000
20 | -684261 | -661695 | -6703 | -5000
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 145102
2001-08-20 00:00:00
CBS Dollars
 |  |  | 448413.9
Spreadsheet: 811866d1672844509-how-to-assign-a-color-to-a-cell-referencing-a-text-for-multiple-entries-color-sample
Sheet: Sheet1

Name | Month
[NAME] | September
[NAME] | September
[NAME] | September
Victor | September
[NAME] | September
[NAME] | September
[NAME] | October
[NAME] | October
[NAME] | October
Victor | October
[NAME] | October