tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 174273d1344981431-scoreboard-wins-1-up-copy-of-testcourse-1-
Sheet: Testing

Test Course
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player: | Test Player
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Count of GIR | Number of holes - par 3's | Missed Left | Missed Right | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL | Count of GIR | Number of holes - par 3's |  |  |  | FairwayHits | MissedLeft | MissedRight
MENS | 139 | 433 | 580 | 399 | 270 | 279 | 215 | 486 | 399 |  |  |  |  |  | 350 | 454 | 153 | 394 | 186 | 422 | 283 | 268 | 552
HANDICAP | 9 | 4 | 1 | 3 | 7 | 8 | 6 | 5 | 2 |  |  |  |  |  | 6 | 1 | 7 | 5 | 3 | 4 | 9 | 8 | 2
PAR | 3 | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 4 |  |  |  |  |  | 4 | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 5
SCORE | 1 | 3 | 4 | 5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 9 | 5 | 4 | 5
[NAME]
[NAME]?
ROUND SCORE
 |  | Eagle |  | [NAME] |  | Par |  | [NAME] |  |  |  |  |  | 2Bogey+
 | 2012-04-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player: | Test Player2
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Count of GIR | Number of holes - par 3's | Missed Left | Missed Right | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
MENS | 139 | 433 | 580 | 399 | 270 | 279 | 215 | 486 | 399 |  |  |  |  |  | 350 | 454 | 153 | 394 | 186 | 422 | 283 | 268 | 552
HANDICAP | 9 | 4 | 1 | 3 | 7 | 8 | 6 | 5 | 2 |  |  |  |  |  | 6 | 1 | 7 | 5 | 3 | 4 | 9 | 8 | 2
PAR | 3 | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 4 |  |  |  |  |  | 4 | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 5
SCORE | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 1 | 1 |  |  |  |  |  | 4 | 5 | 6 | 7
[NAME]
[NAME]?
ROUND SCORE
 |  | Eagle |  | [NAME] |  | Par |  | [NAME] |  |  |  |  |  | 2Bogey+
Spreadsheet: 703909d1605222232-solution-to-finding-formula-to-see-if-two-columns-in-the-same-row-contain-matching-informa-matching_data_practice
Sheet: Sheet1

Name | R NUMBER | File Name | test
238f2hf823gnn | 0 | 238f2hf823gnn_RO.pdf
fh8f2hffhhhhfn22 | 3 | fh8f2hff3hhhhfn22.pdf
484hh44b | 2 | 484hh44b3.pdf
432432t2gf_R7 | 7 | 432432t2gf_R7.pdf
8hghhhhh8888_R3 | 3 | 8hghhhhh8888_R3.pdf
Spreadsheet: andy_zipper__190__Broker detail 5-21-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 6 | 7
 | [NAME]: counterparty has no offer access to product |  | 2 | 2
 | FAILURE: Limit price violated |  | 12 | 12
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 6 |  | 6
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 11 | 2 | 13
APB Energy, Inc. Total |  | 20 | 22 | 42
Natsource LLC | FAILURE: counterparty exceeded credit limit |  | 5 | 5
 | [NAME]: counterparty has no bid access to product | 1 | 3 | 4
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 8 | 9
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 8 | 9
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 4 | 31 | 35
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 1 |  | 1
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 2 |  | 2
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 17 |  | 17
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
Amerex Natural Gas I, Ltd. Total |  | 4 |  | 4
Amerex Power, Ltd. | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 1 | 1
Grand Total |  | 45 | 54 | 99
Spreadsheet: 46265d1245165431-nested-if-functions-drug-half-life-calc-1
Sheet: Sheet2

 |  |  |  |  |  |  | Half-Life | Dosage
Day | Days | "X"value | Dose | Concentration (formula) |  |  | 16 | 400
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Saturday | 6
Sunday | 7
Monday | 8
Tuesday | 9
Wednesday | 10
Thursday | 11
Friday | 12
Saturday | 13
Sunday | 14
Monday | 15
Tuesday | 16
Wednesday | 17
Thursday | 18
Friday | 19
Saturday | 20
Sunday | 21
Monday | 22
Tuesday | 23
Wednesday | 24
Thursday | 25
Friday | 26
Saturday | 27
Sunday | 28
Monday | 29
Tuesday | 30
Wednesday | 31
Thursday | 32
Friday | 33
Saturday | 34
Sunday | 35
Monday | 36
Tuesday | 37
Wednesday | 38
Thursday | 39
Friday | 40
Saturday | 41
Sunday | 42
Monday | 43
Tuesday | 44
Wednesday | 45
Thursday | 46
Friday | 47
Saturday | 48
Sunday | 49
Monday | 50
Tuesday | 51
Wednesday | 52
Thursday | 53
Friday | 54
Saturday | 55
Sunday | 56
Monday | 57
Tuesday | 58
Wednesday | 59
Thursday | 60
Friday | 61
Spreadsheet: kevin_presto__20027__positions
Sheet: Power Off-Peak Positions

Report Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHECK FIGURE | Do Not close this program until all purples are ZERO!!! |  | M:\common\power\riskmgmt\lcra\lcra_newexotica.xls
 |  |  |  |  | M:\common\power\riskmgmt\lcra\lcra_newexotica.xls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M:\Genco\Position\spread position 16 hr.xls
East Power Positions - Off-Peak
 |  | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 |  | 2002-01-01 00:00:00 | 2002-03-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 |  | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2022-12-31 00:00:00
 |  | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2001 Total | Jan-Feb '02 | Mar-Apr '02 | May '02 | June '02 | Jul-Aug '02 | Sep '02 | Oct-Dec '02 | 2002 Total | 2003 | >=2004 | Total Off-Peak |  |  |  |  |  | Check
10 Min Spin | TenMinSpin
10 Min Non-Spin | TenMinNonSpin
Operating Reserves | OpRes
AGC | AGC
UI Congestion Up-lift | NEPOOLU
ICAP | ICAP
Regulation Up | RegulationUp
Regulation Down | RegulationDown
Responsive Reserve | ResponsiveReserve
Non-Spinning Reserve | Non-SpinningReserve
Renewable Energy Credits | RenewableEnergyCredits
UI Congestion Up-lift | NEPOOLU
NEPOOLP | NEPOOLP
NEPOOL | NEPOOL
NEPOOL | NEPOOL
PJM - Eastern Hub | EASTERN HUB
PJM - Western Hub | PJM
[NAME] | NYPP-G
NY Zone A | NYPP-A
NY Zone J | NYPP-J
NE Position
INTO AEP | INTO AEP
Cinergy | Cinergy
Cinergy Plant | CinergyP
Cinergy
OPPD/NPPD | MAPP
[NAME] | Comed
[NAME] Plant | ComedP
Comed
TVA | TVA
TVA Plant | TVAP
TVA
Entergy | Entergy
SOCO | SOCO
FLA_GA | FLA_GA
FPL_FRCC | FPL_FRCC
MW/SE Position
ERCOT Trading | ERCOT
ERCOT Plant | ERCOTP
ERCOT
North Texas | North Texas
North Texas- spread | North TexasP
North Texas
Texas Valley | Texas Valley
Texas Valley- spread | Texas ValleyP
South Texas
Total East Desk Power Position
 |  | 2001-09-01 00:00:00 | 2001-09-01 00:00:00 | 2001-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2005-01-01 00:00:00 |  |  |  | Check
do not delete this - used for Wind position above!!
Heat-Swap & Spread-Opt Power Pos |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Power
Calpine (Heat Swap) | CALPINEENESER
Total Power Pos For Heat-Swap
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -143827.7633103208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 443252.8057480767
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 299425.0424377559
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -478965.2595566658
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -355507.0138621496
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 605745.3878489146
Spreadsheet: 846460d1697644769-copy-all-items-listed-by-title-in-house-water-testing-results
Sheet: Helper 2023 2024

 | Weekly |  |  | Monthly |  |  | Quarterly |  |  | Final_Rinse_Filling_Hose |  |  | Requested_Test
Weekly | Mains Tank 1 |  | Monthly | Filling Room Hand Sink |  | Quarterly | Lab Office Sink
Weekly | Mains Tank 2 |  | Monthly | Filling Room Utensils Sink |  | Quarterly | Lab Chemi Sink
Weekly | Mains Tank 3 |  | Monthly | Pergal Line Sink |  | Quarterly | Lab Bacti Sink
Weekly | [NAME] (USE FINAL_RINSE_DAIRY) |  | Monthly | Pasteuriser Room Hand Sink |  | Quarterly | Canteen Yard Sink
Weekly | [NAME] |  | Monthly | Pasteuriser Room Utensil Sink |  | Quarterly | Dairy Canteen Sink
Weekly | Soft Water Tank |  | Monthly | Red Zone Junction Sink |  | Quarterly | Low Care Junction Sink
Weekly | Shower 1 |  | Monthly | Water dispenser [NAME] |  | Quarterly | Evap 1 Sink
Weekly | Shower 2 |  | Monthly | Water dispenser Dairy Canteen |  | Quarterly | [NAME]
Weekly | Shower 3 |  |  |  |  | Quarterly | Separator Room Utensils Sink
Weekly | Shower 4 |  |  |  |  | Quarterly | Dairy Male Toilet Sink
Weekly | Shower 5 |  |  |  |  | Quarterly | Dairy Female Toilet Sink
Weekly | Shower 6 |  |  |  |  | Quarterly | Milk Reception Sink
Weekly | Shower 7
Weekly | Shower 8
Weekly | Shower 9
Weekly | Shower 10
Weekly | Shower 11 |  |  | .
Weekly | Shower 12 |  |  | .
 |  |  |  | .
 |  |  |  | .
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
 |  |  |  |  |  |  | .
Spreadsheet: 172901d1344365262-calculation-time-too-high-calculation-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Your formula |  | Helper | [NAME] using helper |  |  | [NAME] without helper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9587
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22547
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17640
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43569
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14571
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33936
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45971
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29781
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24034
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35963
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3599
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19035
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40686
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41995
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44055
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19954
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41312
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25452
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24910
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31204
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14458
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9092
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10188
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11212
Spreadsheet: 883624d1732259182-fx-table-multiplication-fx-bsb-
Sheet: Sheet1

 |  | FX Table
 |  | FX | Jan | Feb | Mar | Apr
 |  | AUD | 3 | 2 | 1 | 2
 |  | INR | 8 | 5 | 5 | 9
 |  | USD | 5 | 9 | 8 | 7
 |  | Region wise Sales Table |  |  |  |  |  |  |  | Output table
 |  | Region | Currency | Jan | Feb | Mar | Apr |  | Region | Currency | Jan | Feb | Mar | Apr |  | `
 |  | Region 1 | AUD | 359 | 411 | 391 | 365 |  | Region 1 | AUD
 |  | Region 1 | INR | 340 | 276 | 482 | 253 |  | Region 1 | INR
 |  | Region 1 | USD | 401 | 487 | 272 | 273 |  | Region 1 | USD
 |  | Region 2 | AUD | 378 | 323 | 254 | 320 |  | Region 2 | AUD
 |  | Region 2 | INR | 479 | 282 | 455 | 437 |  | Region 2 | INR
 |  | Region 2 | USD | 453 | 450 | 439 | 482 |  | Region 2 | USD
 |  | Region 3 | AUD | 318 | 482 | 371 | 491 |  | Region 3 | AUD
 |  | Region 3 | INR | 361 | 275 | 356 | 455 |  | Region 3 | INR
 |  | Region 3 | USD | 450 | 304 | 373 | 286 |  | Region 3 | USD
Spreadsheet: 1c7f7c5b-1dc0-4498-bae3-647c6b19fa67
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
POSA | Test | POSA | Posaconazole, Serum | Posaconazole, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 2 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 2 mL | 0.6 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | >700 ng/mL (trough) | Tuesday, Thursday, Sunday; 11:30 p.m. | 2 days | 5 days | 1 | 80299 |  |  |  |  | Rochester
POSA | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
POSA | Result | 89591 | Posaconazole, S | Posaconazole, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53731-6 | Posaconazole:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 842693d1694700923-goal-seek-or-what-if-analysis-not-to-calculate-the-total-revenue-beyond-certain-date-book1
Sheet: Sheet1

Date | 2023-08-31 00:00:00 |  | Department | Company B
 |  |  | Finance | 1270
 |  |  | HR | 3560
 |  |  | IT | 2450
 |  |  | Facilities | 1350
 |  |  | Operations | 4200
 |  |  | Legal | 4450
 |  |  | Commercial | 6310
 |  |  | Projects | 7570
 |  |  | Logistics | 3890
 |  |  | Maintenance | 5650
 |  |  | Transport | 5260
 |  |  | Total Revenue
Spreadsheet: 123195d1317397012-drop-down-selection-that-copies-cells-employee-ranking
Sheet: Employee Report

Employee: | [NAME]
Month: | September
 |  |  |  |  | Improved over previous week |  | Improved over previous week |  | Improved over previous week |  | Improved over previous week
 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Hardware
Accessories
Content
Connection
GSBTP
Services
NMPT
 |  |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal
 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Branded Payments
# of Shifts |  |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A
 |  | Mid Month Checkin |  |  | Date |  | End of Month Checkin |  |  |  |  | Date
Employee Signature |  |  |  |  |  |  | Employee Signature
Supervisor Signature |  |  |  |  |  |  | Supervisor Signature
Employee: | [NAME]
Month: | September
 |  |  | Improved over previous month |  | Improved over previous week |  | Improved over previous week |  | Improved over previous week |  | Improved over previous week
 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Hardware |  | 0.25 |  | 0.45 |  | 0.55 |  | 0.85 |  | 0.86
Accessories |  | 0.1 |  | 0.105 |  | 0.11 |  | 0.12 |  | 0.13
Content
Connection
GSBTP
Services
NMPT
 |  |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal |  | [NAME] to Goal
 |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Branded Payments
# of Shifts |  |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A
 |  | Mid Month Checkin |  |  |  |  | End of Month Checkin
Employee Signature |  |  |  |  |  |  | Employee Signature
Supervisor Signature |  |  |  |  |  |  | Supervisor Signature
Spreadsheet: 873503d1720008196-how-to-combine-daily-sales-remaining-stock-into-one-table-how-to-combine-daily-sales-remaining-stock-into-one-table
Sheet: Sales

Daily Sales Recording
Date | Order Number | Name | Phone Number | Orange | [NAME] | Mango | Price | Transport Fee | Total | Channel | Month
2024-07-01 00:00:00 | 33-1525 | [NAME] |  | 9 | 9 |  |  |  |  |  |  |  | 1) Split the sales and stocks into separate tables
2024-07-01 00:00:00 | 33-1526 | [NAME] |  | 3 | 3 | 3 |  |  |  |  |  |  | 2) Update daily sales in the Sales Table
2024-07-01 00:00:00 | 33-1527 | [NAME] |  | 6 | 6 | 6 |  |  |  |  |  |  | 3) [NAME] in Stocks Table will then pick up total daily sales by product
2024-07-01 00:00:00 | 33-1528 | Amazon |  | 9 | 9 |  |  |  |  |  |  |  | 4) Create another sheet for sales analysis purpose using PivotTables
2024-07-01 00:00:00 | 33-1529 | Alibaba |  | 3 | 3 | 3 |  |  |  |  |  |  | 5) Refresh PivotTables whenever new data is entered in Sales Table
2024-07-02 00:00:00 | 33-1530 | [NAME] |  | 3 | 3 | 3
2024-07-02 00:00:00 | 33-1531 | veronia |  |  | 6
2024-07-02 00:00:00 | 33-1532 | olivia |  | 12 |  | 12
2024-07-02 00:00:00 | 33-1533 | Amazon |  | 3 | 3
2024-07-02 00:00:00 | 33-1534 | Alibaba |  |  |  | 9
2024-07-03 00:00:00 | 33-1535 | [NAME] |  | 3 | 3 | 3
2024-07-03 00:00:00 | 33-1536 | phei |  |  | 6 | 6
2024-07-03 00:00:00 | 33-1537 | [NAME] |  |  | 10 | 9
2024-07-03 00:00:00 | 33-1538 | Amazon |  | 9
2024-07-04 00:00:00 | 33-1540 | [NAME] |  | 6
2024-07-04 00:00:00 | 33-1541 | [NAME] |  |  | 3
2024-07-04 00:00:00 | 33-1542 | [NAME] |  |  | 3
2024-07-04 00:00:00 | 33-1543 | Amazon |  |  | 6
2024-07-04 00:00:00 | 33-1544 | Alibaba |  | 3
2024-07-05 00:00:00 | 33-1545 | [NAME] |  | 6
2024-07-05 00:00:00 | 33-1546 | phei |  | 3 | 3 | 9
2024-07-05 00:00:00 | 33-1547 | [NAME] |  | 6
2024-07-05 00:00:00 | 33-1548 | Amazon |  |  | 3
2024-07-05 00:00:00 | 33-1549 | Alibaba |  | 24 | 12 | 12
Spreadsheet: c7e3c5d9-3ecb-43e1-8b88-6cf2c190a447
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2012
 |  | Data Extracted on: May 20, 2013 (1:19 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229175 | 233474 | 235336 | 238105
2005 | 241837 | 244380 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276013 | 278199 | 280692 | 273583
2009 | 267567 | 267416 | 268461 | 271132
2010 | 273221 | 275247 | 279408 | 281844
2011 | 284136 | 290132 | 292370 | 293684
2012 | 296657 | 298058 | 300019 | 309655
Spreadsheet: 779070d1651574418-dynamic-formula-to-retrieve-departments-and-totals-greater-than-0-book3
Sheet: data

Employee# | Surname | nName | remnant | vacation | 1.25%
dep 1:  People
60 | surname1 | name1 | 6 | 5676 |  | [NAME] : People | 20730
93 | surname2 | [NAME] | 6 | 1080 |  | Customer Success : Technical Support | 16365
99 | surname3 | name3 | 2.5 | 2653 |  | Engineering : Archiver | 598.75
122 | surname4 | name4 | 2 | 1661
184 | surname5 | name5 | 4 | 2400 |  |  | 20730
185 | surname6 | name6 | 0.5 | 577 |  | Customer Success : Technical Support | 16365
194 | surname7 | name7 | 3 | 2492 |  | Engineering : Archiver | 598.75
199 | surname8 | name8 | -1.65 | -1142
212 | surname9 | name9 | 1.39 | 1187
total employees for dep 1: 9 |  |  | 24 | 16584
dep 3:   Business Developm
22 | surname10 | name10 | -0.313 | -328
total employees for dep 3: 1 |  |  | 0 | -328
dep 4:  Customer Success Manageme
52 | surname11 | name11 | -7 | -12792
54 | surname12 | name12 | 0.095 | 62
189 | surname13 | name13 | 1 | 738
193 | surname14 | name14 | 3 | 2769
total employees for dep 4: 4 |  |  | -3 | -9223
dep 5:   Technical Support
61 | surname15 | [NAME] | 2.5 | 2884
137 | surname16 | [NAME] | 2 | 1645
157 | surname17 | name17 | -1 | -1036
175 | surname18 | name18 | 4 | 3692
178 | surname19 | name19 | 4 | 5907
total employees for dep 5: 5 |  |  | 12 | 13092
dep 6:  Archiver
18 | surname20 | name20 | -0.833 | -1730
32 | surname21 | [NAME] | 0 | 0
33 | surname22 | name22 | 2 | 3184
41 | surname23 | name23 | -0.5 | -842
64 | surname24 | name24 | 4.5 | 8929
71 | surname25 | name25 | 5.5 | 10660
73 | surname26 | [NAME] | -0.5 | -1108
87 | surname27 | name27 | -0.5 | -900
106 | surname28 | name28 | -3.5 | -5814
112 | surname29 | name29 | -3 | -4915
113 | surname30 | name30 | -8 | -12736
115 | surname31 | name31 | -4 | -5076
154 | surname32 | name32 | 3 | 3461
162 | surname33 | name33 | 3 | 4845
195 | surname34 | [NAME] | 2.77 | 3324
201 | surname35 | name35 | 0.5 | 969
215 | surname36 | name36 | -1.28 | -1772
total employees for dep 6: 17 |  |  | -1 | 479
Spreadsheet: 668248d1584711864-index-match-match-book1
Sheet: Updated Schedule

DeptCode | [NAME] | RequiredMANAGER | SCHED | SUN | MON | TUE | WED | THU | FRI | SAT
IQOR.OPS.TCM.TX.MET.W.TP.TMB | Supervisor 1 | Manager 1 | Tue-Sat | Off | OFF | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00
IQOR.OPS.TCM.TX.MET.W.CP.TMC | Supervisor 2 | Manager 2 | Tue-Sat | OFF | OFF | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00
IQOR.OPS.TCM.TX.MET.W.TP.TMG | Supervisor 3 | Manager 2 | Wed-Sun | 07:00-16:00 | OFF | OFF | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00
IQOR.OPS.TCM.TX.MET.W.TP.TMG | [NAME] | Manager 3 | Sat-Wed | 15:00-00:00 | 15:00-00:00 | 15:00-00:00 | 15:00-00:00 | OFF | OFF | 15:00-00:00
IQOR.OPS.TCM.TX.MET.W.TP.TMD | Supervisor 5 | Manager 3 | Thu-Mon | 15:00-00:00 | 15:00-00:00 | OFF | OFF | 15:00-00:00 | 15:00-00:00 | 15:00-00:00
IQOR.OPS.TCM.TX.MET.W.TP.TMA | Supervisor 6 | Manager 3 | Thu-Mon | 07:00-16:00 | 07:00-16:00 | OFF | OFF | 07:00-16:00 | 07:00-16:00 | 07:00-16:00
IQOR.OPS.TCM.TX.MET.W.TH.TMM | Supervisor 7 | Manager 3 | Sat-Wed | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | 07:00-16:00 | OFF | OFF | 07:00-16:00
IQOR.OPS.TCM.TX.MET.W.TH.TMF | Supervisor 8 | Manager 3 | Sat-Wed | 15:00-00:00 | 15:00-00:00 | 15:00-00:00 | 15:00-00:00 | OFF | OFF | 15:00-00:00
Spreadsheet: 729693d1619262315-formula-to-count-absences-based-on-criteria-and-matching-dates-updated
Sheet: Sheet1

Employee | Date | Hours Type | Code |  | Absences Formula #1 | Absences Formula New #1
[NAME] | 2021-02-01 00:00:00 | LA | #
[NAME] | 2021-02-02 00:00:00 | RF | TS
[NAME] | 2021-02-03 00:00:00 | RF | #
[NAME] | 2021-02-04 00:00:00 | RF | TS
[NAME] | 2021-02-04 00:00:00 | LS | #
[NAME] | 2021-02-08 00:00:00 | RF | TS
[NAME] | 2021-02-09 00:00:00 | RF | #
[NAME] | 2021-02-10 00:00:00 | OS | #
[NAME] | 2021-02-01 00:00:00 | LA | #
[NAME] | 2021-02-02 00:00:00 | RF | #
[NAME] | 2021-02-03 00:00:00 | RF | #
[NAME] | 2021-02-04 00:00:00 | RF | TS
[NAME] | 2021-02-04 00:00:00 | LS | #
[NAME] | 2021-02-08 00:00:00 | RF | TS
[NAME] | 2021-02-09 00:00:00 | RF | TS
[NAME] | 2021-02-10 00:00:00 | OS | #