tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58709d1258986935-macro-code-amendent-for-changing-worksheet-name-required-cover
Sheet: Menu

 |  | Vision Workbook 1
 | 1 |  | Worksheet1
 | 2 |  | Accounts
 |  |  | TCode5 / Breakout
 | 3 |  | ! / Not Analysed
 | 4 |  | AIR / BRUNEI AIRPORT
 | 5 |  | ATH / ATHIRAH
 | 6 |  | BB / BUNUT
 | 7 |  | BSP / ATM BSP S/B HQ
 | 8 |  | DEL / ATM DELIMA JAYA  JLN MUARA
 | 9 |  | GDG / GADONG SUPASAVE
 | 10 |  | GEN / General
 | 11 |  | GIA / ATM-CASH A/C - GIANT
 | 12 |  | JB / BERAKAS
 | 13 |  | JG / GADONG
 | 14 |  | KB / KUALA BELAIT
 | 15 |  | KIU / KIULAP
 | 16 |  | LAM / ATM PERPINDAHAN LAMBAK
 | 17 |  | LNG / BLNG
 | 18 |  | MAB / MABOHAI
 | 19 |  | MALL / ATM THE MALL
 | 20 |  | MO / MAIN OFFICE
 | 21 |  | MT / MUARA
 | 22 |  | PRBJG / PRIORITY BANKING JLN GADONG
 | 23 |  | PRBKB / Priority Banking Kuala Belait
 | 24 |  | PRBMO / PRIORITY BANKING MAIN OFFICE
 | 25 |  | SGL / ATM-CASH A/C - SUNGAI LIANG
 | 26 |  | SK / SENGKURONG
 | 27 |  | SKG / ATM HUA HO SENGKURONG
 | 28 |  | SR / SERIA
 | 29 |  | TAN / TANJONG BUNUT
 | 30 |  | TT / TUTONG TOWN
 | 31 |  | YAK / ATM WISMA YAKIN SERIA
 | 32 |  | YAY / YAYASAN
Spreadsheet: 162137d1339741974-need-to-count-non-blank-cell-depends-on-another-two-cell-criteria-cricket_score_sheet
Sheet: Sheet1

Points | Score | Cricket Teams |  | Score | Points
3 | 122 | AAA | BBB | 100 | 0
1 | 114 | DDD | CCC | 114 | 1
0 | 150 | EEE | FFF | 153 | 3
0 | 129 | AAA | CCC | 130 | 3
N/A |  | EEE | DDD |  | N/A
N/A |  | FFF | AAA |  | N/A
N/A |  | DDD | AAA |  | N/A
N/A |  | CCC | BBB |  | N/A
N/A |  | BBB | FFF |  | N/A
N/A |  | BBB | EEE |  | N/A
N/A |  | CCC | AAA |  | N/A
Spreadsheet: 586479d1534411505-scoring-between-tables-looking-at-data-set-scoring-table-tennis
Sheet: Sheet1

Table Tennis Scoring
Date |  | Player 1 | Player 2 | Score Player 1 | Score Player 2 | [NAME] 1 | [NAME] 2 |  | Individual: | Win % |  | Player vs Player | Win % |  | Player vs Player | Average score
2018-08-16 00:00:00 | Game 1 | [NAME] | [NAME] | 11 | 7 | Win | Lose |  | [NAME] |  |  | [NAME]: [NAME] vs [NAME] | 0.29 |  | [NAME]: [NAME] vs [NAME] | 9.14
 | Game 2 | [NAME] | [NAME] | 5 | 11 | Lose | Win |  | [NAME] |  |  | [NAME]: [NAME] [NAME] | 0.71 |  | [NAME]: [NAME] [NAME] | 10.42
 | Game 3 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  | Kurt H |  |  | [NAME]: [NAME] | 0.67 |  | [NAME]: [NAME] | 10.33
 | Game 4 | [NAME] | [NAME] | 11 | 9 | Win | Lose |  |  |  |  | Kurt H: [NAME] | 0.33 |  | Kurt H: [NAME] | 7
 | Game 5 | [NAME] | [NAME] | 9 | 11 | Lose | Win |  |  |  |  | [NAME]: [NAME] vs Kurt H | 1 |  | [NAME]: [NAME] vs Kurt H | 11
 | Game 6 | [NAME] | [NAME] | 8 | 11 | Lose | Win |  |  |  |  | Kurt H: [NAME] vs Kurt H | 0 |  | Kurt H: [NAME] vs Kurt H | 5.5
 | Game 7 | [NAME] | [NAME] | 11 | 13 | Lose | Win
 | Game 8 | [NAME] | Kurt H | 11 | 6 | Win | Lose
 | Game 9 | [NAME] | Kurt H | 11 | 4 | Win | Lose
 | Game 10 | [NAME] | Kurt H | 9 | 11 | Lose | Win
 | Game 11 | [NAME] | Kurt H | 11 | 3 | Win | Lose
 | Game 12 | [NAME] | Kurt H | 11 | 8 | Win | Lose
Spreadsheet: 195448d1353517719-linking-a-worksheet-to-a-pivot-table-example
Sheet: Site analysis P&L

Sum of GoodsValueInBaseCurrency
 | Department | Site 1 | Site 2 | Site 3
Turnover | Turnover
Sales | Sales
Direct Expenses | Direct Expenses
Direct Wages Gross | Direct Wages Gross
Direct Wages ERS NIC | Direct Wages ERS NIC
Total Direct Costs | Total Direct Costs
Gross Profit | Gross Profit
Staff Wages | Staff Wages
Branch staff salaries and ERS NIC | Branch staff salaries and ERS NIC
Total Staff Wages
Gross Profit After Staff Wages | Gross Profit After Staff Wages
Overheads | Overheads
Rent and Rates | Rent and Rates
Heat, Light and Power | Heat, Light and Power
Motor Expenses | Motor Expenses
Travelling and Entertainment | Travelling and Entertainment
Printing and Stationery | Printing and Stationery
Professional Fees | Professional Fees
Bank Charges and Interest | Bank Charges and Interest
Bad Debts | Bad Debts
General Expenses | General Expenses
Suspense & Mispostings | Suspense & Mispostings
Insurances | Insurances
Repairs and renewals | Repairs and renewals
Hotels | Hotels
Staff Entertaining | Staff Entertaining
Work wear | Work wear
Vehicle Leasing | Vehicle Leasing
Telephone | Telephone
Computer maintenance and support | Computer maintenance and support
Other Pensions | Other Pensions
[NAME] Claims | [NAME] Claims
Advertising | Advertising
Staff Training | Staff Training
Depreciation | Depreciation
Class 1A NIC | Class 1A NIC
Clock Card Costs | Clock Card Costs
Total Overheads | Total Overheads
Wage Deductions | Wage Deductions
[NAME] | [NAME]
Workwear Deposits | Workwear Deposits
Parking Fine Contributions | Parking Fine Contributions
Total Wage Deductions | Total Wage Deductions
Profit and Loss before Tax | Profit and Loss before Tax
Spreadsheet: 494084d1482166564-cant-sum-cells-book2
Sheet: REPORT CARD

Wentzville    Nov. 2015 | Total | Total QTY | Quantity PM | Quantity PM | Total Comp | Quantity PM | Total Comp | Defects | F/U | Created | Completed | Total | EM | Total | PM Hrs | PM | % While | PM DTR | % PM | % PM | % PM | PM | CM
Dept | Quantity PM | DTR PM | w/o estimates | w/o times | Quantity PM | w/o actuals | Hours PM | Found | W/O | Total CM | Total CM | EM's | Hours | Defects | ROI | ROI | Running PM | [NAME] | w/ times | w/ est | w/ actual | Comp % | Comp %
Body | 425 | 201 | 0 | 0 | 391 | 388 | * | 18 | 3 | 11 | 7 | 0 | * | * |  |  |  | 2
Paint | 399 | 166 | 31 | 23 | 330 | 151 | * | 16 | 0 | 18 | 5 | 0 | * | * |  |  |  | 100
GA | 2003 | 826 | 0 | 0 | 1818 | 1522 | * | 104 | 2 | 1 | 0 | 90 | * | * |  |  |  | 273
Stamping | 100 | 40 | 0 | 0 | 75 | 69 | * | 0 | 0 | 0 | 0 | 0 | * | * |  |  |  | 0
WFG | 713 | 220 | 52 | 42 | 583 | 124 | * | 29 | 32 | 39 | 8 | 0 | * | * |  |  |  | 33
Plant Total | 3640
EACH OF THE DEPARTMENTS AND THE TOTAL | TOTAL NUMBER OF PM's & PdM's INITIATED | QUANTITY OF PM's or PdM's WORKORDERS THAT HAVE THE "DOWNTIME" FIELD SET TO "Y" | PM's INITIATED WITHOUT ESTIMATES ON JOB PLAN | PM's & PdM's WORKORDERS THAT DO NOT HAVE EITHER ESTIMATED or ACTUAL TIME | TOTAL COMPLETED OR CLOSED PM's | PM's & PdM's WITHOUT ACTUALS RECORDED | TOTAL HOURS OF PM & PdM WORKORDERS COMPLETED - ACTUAL TIME IS USED.  IF NO ACTUAL TIME THEN ESTIMATED IS USED.  IF NEITHER USED THEN AVERAGE TIME OF THAT WORKTYPE IS USED.  ALL WORKORDERS ARE FORCED TO HAVE A TIME VALUE. | NUMBER OF COMPLETED or CLOSED PM/PdM WORKORDERS THAT HAVE THE "DEFECTS FOUND" FIELD SET TO "Y" | TOTAL NUMBER OF PM/PdM WORKORDERS COMPLETED or CLOSED THAT HAVE A "Y" IN THE FOLLOWUP WORKORDERS FIELD BUT DO NOT HAVE THE DEFECT FOUND BOX CHECKED (TO PREVENT DOUBLE COUNTING) | TOTAL NUMBER OF CM's WRITTEN | TOTAL NUMBER OF CM's COMPLETED OR CLOSED ON TIME | TOTAL NUMBER OF EM's INITIATED | ACTUALS RECORDED ON EM's.  IF NO ACTUAL TIME VALUE IS ENTERED, THEN THE AVERAGE OF THAT WORKTYPE IS ENTERED.  ALL WO's ARE FORCED TO HAVE A TIME VALUE. | SUM TOTAL OF CM's CREATED, PM/PdM WORKORDERS WITH "DEFECTS FOUND" or "FOLLOW-UP WORKORDERS" | ROI = HOURS OF PM / #CM's + # DEFECTS FOUND + # FOLLOUP WO's | ROI = QUANTITY OF PM'S / #CM's + # DEFECTS FOUND + # FOLLOUP WO's | PERCENTAGE OF PM's THAT CAN BE DONE WHILE LINE IS RUNNING | HOURS OF PM/PdM WORKORDERS THAT HAVE THE "DOWNTIME" FIELD SET TO "Y" | PM's WITH DURATION ON PM | PM's WITH ESTIMATES RECORDED | PM's WITH ACTUALS RECORDED | PERCEMTAGE OF PM's COMPLETED or CLOSED | PERCEMTAGE OF CM's COMPLETED or CLOSED
Spreadsheet: 888937d1739559326-calendar-conditional-formatting-and-between-date-range-highlights-building-calendar
Sheet: Calendar

 | Month | Year
 | February | 2025
 |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  | December
Spreadsheet: 111935d1308163309-average-time-am-pm-when-various-criteria-are-met-sample
Sheet: AVERAGES

AVERAGES
COLLECTOR |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | WEEKLY TOTAL
EXT | NAME | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION | FIRST CALL | LAST CALL | TOTAL  CALLS | TOTAL  DURATION
7012 | a
7023 | b
7014 | c
7008 | d
7011 | e
7032 | f
7016 | g
7018 | h
7015 | i
7013 | j
COURT TOTALS
COURT AVERAGE
7010 | x
7022 | y
7019 | z
CONSUMER TOTALS
CONSUMER AVERAGE
COMBINED TOTALS
COMBINED AVERAGE
Spreadsheet: 96030d1295511201-rank-size-within-lake-lake_species_size_rank
Sheet: Sheet1

LAKE | SPECIES | SIZE | RANK
A | bass | 15 |  |  | Lake is in random order
B | catfish | 20 |  |  | Species is in random order
C | bass | 14
D | crappie | 12 |  |  | Find rank of SPECIES within each LAKE
A | bass | 14.5
B | bass | 13
C | crappie | 11
D | crappie | 13
A | catfish | 21
B | catfish | 19
C | catfish | 20
D | bass | 15
Spreadsheet: 93777d1293555024-conditional-formatting-using-ifs-help-please-gwynemark_sample
Sheet: Sheet1

Planned Closure Date | Status of Corrective Action |  |  |  |  |  |  |  | Planned Closure Date | Status of Corrective Action
2010-11-15 00:00:00 | Open |  |  | 1) I would like column A to color code the cells in RED if the date is greater than 30 days from today and the Status (column B) is "open" |  |  |  |  | 2010-11-15 00:00:00 | Open
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-12-10 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-10 00:00:00 | Closed
2010-08-11 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-08-11 00:00:00 | Closed
2010-09-11 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-09-11 00:00:00 | Closed
2010-10-04 00:00:00 | Open |  |  |  |  |  |  |  | 2010-10-04 00:00:00 | Open
2010-12-01 00:00:00 | Open |  |  | 2) If possible, I would also like to color code the cell YELLOW if the date is within 30 days of today and the status (column B) is "open" |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-06-15 00:00:00 | Open |  |  |  |  |  |  |  | 2010-06-15 00:00:00 | Open
2010-06-15 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-06-15 00:00:00 | Closed
2010-08-17 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-08-17 00:00:00 | Closed
2010-12-28 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-28 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  | It should look like this to the right but done automatically. |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | Open
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-11-27 00:00:00 | Open |  |  |  |  |  |  |  | 2010-11-27 00:00:00 | Open
2010-11-26 00:00:00 | Closed |  |  |  |  |  |  |  | 2010-11-26 00:00:00 | Closed
Spreadsheet: 199761d1355320644-change-to-multiple-worksheets-in-same-file-thesechanges
Sheet: Database

ITEMS | CHANGES | ADDITIONS
AC ADAPTOR | AC ADAPTOR
ADSL FILTER | ADSL FILTER
AERIAL BOOSTER | AERIAL BOOSTER
AIR COOLER | AIR COOLER
ALARM CLOCK | ALARM CLOCK
ALL IN ONE PRINTER | PRINTER ALL IN ONE
AMERICAN STYLE FRIDGE FREEZER | AMERICAN STYLE FRIDGE FREEZER
AMPLIFIER | AMPLIFIER
[NAME] | GUITAR AMPLIFIER
ANGLE GRINDER | ANGLE GRINDER
ANSWER MACHINE | ANSWER MACHINE
AUDIO CASSETTE | AUDIO CASSETTE
BALANCE BOARD | BALANCE BOARD
BATTERY CHARGER | BATTERY CHARGER
 |  | TV LED 50"
 |  | TV CRT 28"
Spreadsheet: 438afbcf-f787-4a93-b3df-de7431bd2947
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
FZOLP | Test | FZOLP | [NAME] ([NAME]), serum or plasma | [NAME] ([NAME]), Serum | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) |  |  |  |  |  | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:	ng/mL  Expected hypnotic zolpidem concentrations in patients taking recommended daily dosages: up to 250 ng/mL.  Toxic range has not been established.   Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FZOLP | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FZOLP | Result | Z3322 | [NAME], SE | [NAME], SE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: mary_fischer__25641__111
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF OTHER DEFERRED CHARGES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
Rvs double posted salaries |  | 0 |  |  |  |  |  |  |  | 1325
Reclass I/C balance |  | 0 |  |  |  |  |  | 950540 |  | 0051
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 748925d1632414447-return-t-or-f-if-date-is-between-range-test
Sheet: Test

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Start Date | Month Count | End Date | Column11 | Column12 | Column13 | Column14 |  | 2021-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00 | 5 |  |  |  |  |  |  | F | F | F | F | F | T | T | T | T | T | F | F | F | F
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00 | 6
 |  |  |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | 8
 |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | 5
 |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2022-03-01 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 6
 |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00 | 5
Spreadsheet: 169343d1342792391-graph-for-measurements-growth-chart
Sheet: Sheet1

 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001
Timmy | 87.5 | 93.9 | 101 | 109 | 110.5 | 112
Jake | 17 | 24 | 36 | 56 | 72 | 80
[NAME] | 0 | 0 | 0 | 14 | 28 | 32
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Crystal
Spreadsheet: gerald_nemec__11487__Netback calculation - Crescndo
Sheet: San Arroyo  Dakota

 | CURRENT PRICING CALCULATIONS
 | Field Name: | San Arroyo
 | Production Zone: | Dakota
 | Company: | Crescendo Energy, LLC
 | CALCULATED FROM INLET SIDE
 | Flow Rate |  | 3.5 | MMSCFD |  |  |  |  | MMSCFD
 | BTU Content |  | 1.08 | MMBTU/MSCF |  |  |  | 1.09 | MMBTU/MSCF
 | Flow Rate |  |  | MMBTU/D |  |  |  |  | MMBTU/D
 | Sales Price |  |  | /MMBTU |  |  |  |  | MMBTU
 | Processing Fee |  | 0 | /MSCF (INLET) |  |  |  |  | /MSCF (OUTLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | Gathering Fee |  | 0.25 | /MSCF (INLET) |  |  |  |  | /MSCF (INLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | FL&U and Plant Shrink |  |  | MMSCFD
 | (includes gathering/processing) |  |  | MMBTU/DAY
 | Adjusted Sale Price |  |  | /MSCF
 | Fuel Gas Adjustment |  |  | /MSCF
 |  |  |  |  |  | Gathering FL&U |  |  | 0.04
 | Net Back to Producer |  |  | /MSCF |  | Plant Shrink |  |  | 0
 |  |  |  |  |  | Plant Fuel Gas |  |  | 0
 |  |  |  |  |  | Total FL&U and Plant Shrink
 | Revenue per Day |  |  | /DAY
Spreadsheet: 829132d1683948715-merging-index-and-sumproduct-formula-dynamic-range-eba
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mark
 | Dept 1 |  |  |  | Dept 2 |  |  |  | Dept 3 |  |  |  | Dept 4 |  |  |  |  |  | [NAME]
 | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date | Person | Start Date | Hrs | Finish date |  |  | [NAME]
Item A | [NAME] | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 23 |  | [NAME] | 2023-05-15 00:00:00 | 31 |  | [NAME] | 2023-05-12 00:00:00 | 39 |  |  |  | [NAME]
Item B | Mark | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 7 |  | [NAME] | 2023-05-15 00:00:00 | 15 |  | [NAME] | 2023-05-15 00:00:00 | 23 |  |  |  | [NAME]
Item C | [NAME] | 2023-05-17 00:00:00 | 15 |  | [NAME] | 2023-05-18 00:00:00 | 23 |  | [NAME] | 2023-05-19 00:00:00 | 31 |  | [NAME] | 2023-05-12 00:00:00 | 39 |  |  |  | [NAME]
Item D | Mark | 2023-05-17 00:00:00 | 23 |  | [NAME] | 2023-05-16 00:00:00 | 7 |  | [NAME] | 2023-05-17 00:00:00 | 15 |  | [NAME] | 2023-05-18 00:00:00 | 23 |  |  |  | [NAME]
 | Dept 1 | Dept 1 | Dept 2 | Dept 2 | Dept 3 | Dept 3 | Dept 4 | Dept 4
 | [NAME] | Mark | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2023-05-15 00:00:00
2023-05-16 00:00:00
2023-05-17 00:00:00
2023-05-18 00:00:00
2023-05-19 00:00:00
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 44

Tue 3 Apr Glucose mmol/L Wed 4 Apr Glucose mmol/L Thu 5 Apr Glucose mmol/L Fri 6 Apr Glucose mmol/L Sat 7 Apr 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.5 7.5 7.7
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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.8 6.2 6.3 | 7.1 8.2 6.8 | 6.1 6.9 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
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 8 Apr 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
Mon 9 Apr Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Tue 10 Apr Glucose mmol/L
Spreadsheet: 850726d1701113797-add-data-from-multiple-sheets-sample-workbook
Sheet: END OF YEAR REPORT

 | MONTHLY TOTALS
 |  | [NAME] |  | Reimburse
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
Total
Spreadsheet: 85821d1285855034-showing-a-copy-of-data-based-on-dated-entries-most-current-entry-example
Sheet: Sheet1

Most Current Entry to Date:
Date Prepared: |  |  |  |  |  |  |  |  |  | Total
Main Bank:
Kiosk & ESW:
Kiosk & JDU on Floor:
Oustanding Drops:
Order to be Delivered:
Order to be Delivered:
Order to be Deposited:
Inventory After [NAME]:
Date Prepared: | 2010-08-31 00:00:00 | 100 | 20 | 10 | 5 | 1 | 0.25 | 0.05 | 0.01 | Total
Main Bank: | 2010-08-31 00:00:00 | 1000 | 0 | 500 | 0 | 0 | 0 | 0 | 0
Kiosk & ESW: | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Kiosk & JDU on Floor: | 2010-08-31 00:00:00 | 5000 | 0 | 0 | 0 | 3000 | 0 | 0 | 0
Oustanding Drops: | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Deposited: | 2010-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventory After [NAME]:
Date Prepared: | 2010-09-01 00:00:00 | 100 | 20 | 10 | 5 | 1 | 0.25 | 0.05 | 0.01 | Total
Main Bank: | 2010-09-01 00:00:00 | 1000 | 0 | 500 | 0 | 0 | 0 | 0 | 0
Kiosk & ESW: | 2010-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Kiosk & JDU on Floor: | 2010-09-01 00:00:00 | 20000 | 0 | 0 | 0 | 400 | 0 | 0 | 0
Oustanding Drops: | 2010-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Deposited: | 2010-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventory After [NAME]:
Date Prepared: | 2010-09-02 00:00:00 | 100 | 20 | 10 | 5 | 1 | 0.25 | 0.05 | 0.01 | Total
Main Bank: | 2010-09-02 00:00:00 | 1000 | 0 | 500 | 0 | 0 | 0 | 0 | 0
Kiosk & ESW: | 2010-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Kiosk & JDU on Floor: | 2010-09-02 00:00:00 | 700 | 0 | 0 | 0 | 200 | 0 | 0 | 0
Oustanding Drops: | 2010-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Delivered: | 2010-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Order to be Deposited: | 2010-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventory After [NAME]: