tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846419d1697631606-how-to-split-a-cell-value-into-multiple-cells-split-order-into-multiple-payments-test
Sheet: Sample Output - Step 1

Product | Month | Total Cost
Product A | 2023-11-01 00:00:00 |  | <- This block of responses are from the 2000 unit order on Nov-23. Note that Dec-23 is missing as there is no payment during that month per the payment terms sheet
Product A | 2024-01-01 00:00:00
Product A | 2024-02-01 00:00:00
Product A | 2024-02-01 00:00:00 |  | <- This block of responses are from the 3000 unit order on Feb-24. Note that Mar-23 is missing as there is no payment during that month per the payment terms sheet
Product A | 2024-04-01 00:00:00
Product A | 2024-05-01 00:00:00
…repeat for all orders and for all products…
Spreadsheet: 210067d1359375540-advice-on-a-questionnaire-results-questionnaire-results
Sheet: Data

Countries | Resources | Resources Availability | Process | Process Availability | Stakeholder buy in | Stakeholders | %Curricula | #[NAME] | Employees
Wave 1
U.K | Some | 500 | No | 500 | Not Interested | 500 | 0.5 | 100 | 1223
Benelux | Yes | 1000 | Yes | 1000 | Ok | 0 | 0.1 | 54 | 50
Sweden | None | 0 | None | 0 | Not Interested | 500 | 0.2 | 150 | 1000
Spain | Some | 500 | Yes | 1000 | Very Interested | 1000 | 0.4 | 43 | 1223
Portugal | Some | 500 | Yes | 1000 | Not Interested | 500 | 1 | 54 | 400
Wave 2
France | Some | 500 | No | 500 | Not Interested | 500 | 0.83 | 49.3 | 637.3
Egypt | Yes | 1000 | Yes | 1000 | Ok | 0 | 0.9 | 39 | 590
India | None | 0 | None | 0 | Not Interested | 500 | 0.65 | 28.7 | 542.7
Pakistan | Some | 500 | Yes | 1000 | Very Interested | 1000 | 1 | 18.4 | 495.4
Wave 3
Brazil | Some | 500 | Yes | 1000 | Not Interested | 500 | 0.8 | 8.1 | 448.1
Suriname | Some | 500 | No | 500 | Not Interested | 500 | 0.4 | 50 | 400.8
Argentina | Yes | 1000 | Yes | 1000 | Ok | 0 | 0.35 | 45 | 353.5
Colombia | None | 0 | None | 0 | Not Interested | 500 | 0.6 | 13 | 306.2
Malaysia | Some | 500 | Yes | 1000 | Very Interested | 1000 | 0.65 | 140 | 258.9
Wave 4
China | Some | 500 | Yes | 1000 | Not Interested | 500 | 0.8 | 8.1 | 448.1
Taiwan | Some | 500 | No | 500 | Not Interested | 500 | 0.4 | 50 | 400.8
Australia | Yes | 1000 | Yes | 1000 | Ok | 0 | 0.35 | 45 | 353.5
Indonesia | None | 0 | None | 0 | Not Interested | 500 | 0.6 | 13 | 306.2
Singapore | Some | 500 | Yes | 1000 | Very Interested | 1000 | 0.65 | 140 | 258.9
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Daily Deals

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eol |  |  |  |  |  |  |  |  |  |  |  | eol
Term |  |  | Prepay Counterparty | P.O.D. | Volume (MW) | Delivery Pattern | Price | Enpower Deal # | Comments
2001-12-25 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Mead 230kv | 75 | standard LLH | 2 | 893867 | receipt of a PV/Mead swap, the price is the agreed upon spread amount
2001-12-25 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Mead 230kv | 175 | standard LLH | 25 | 893866
2001-12-25 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Pinnacle Peak | 25 | standard LLH | 26.15 | 893858
2001-12-26 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Palo Verde | 9 | [NAME] | 29 | 893860
2001-12-26 00:00:00 | thru | 2001-12-31 00:00:00 | AEP | Palo Verde | 91 | [NAME] | 28 | 893862
2001-12-26 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Mead 230kv | 150 | [NAME] | 31 | 893863
2001-12-26 00:00:00 | thru | 2001-12-31 00:00:00 | Public Service Company of New Mexico | Pinnacle Peak | 25 | [NAME] | 32.15 | 893859
Spreadsheet: 165417d1341226480-need-to-remove-numbes-from-alphanumberic-field-book1
Sheet: Sheet1

 |  | To return IDs (First pass) | To return IDs (Second pass) | To return address
[EMAIL] |  | 22009-[PHONE]-[PHONE] | 22009-[PHONE]-[PHONE] | [EMAIL]
[EMAIL] |  | 22014-[PHONE]-965 | 22014-[PHONE]-965 | [EMAIL]
[EMAIL] |  | 2-201715299-20 | 2-201715299-20 | [EMAIL]
[EMAIL] |  | 22040-[PHONE]-[PHONE] | 22040-[PHONE]-[PHONE] | [EMAIL]
[EMAIL] |  | 2-205829852-205829851 | 2-205829852-205829851 | [EMAIL]
[EMAIL] |  | 22077-[PHONE]-[PHONE] | 22077-[PHONE]-[PHONE] | [EMAIL]
[EMAIL] |  | 22083-[PHONE]-[PHONE] | 22083-[PHONE]-[PHONE] | [EMAIL]
[EMAIL] |  | 220916 | 220916 | [EMAIL]
[EMAIL] |  | 2210143 | 2210143 | [EMAIL]
[EMAIL] |  | 2210143 | 2210143 | [EMAIL]
[EMAIL] |  | 221064 | 221064 | [EMAIL]
[EMAIL] |  | 2211016 | 2211016 | [EMAIL]
[EMAIL] |  | 2211064 | 2211064 | [EMAIL]
[EMAIL] | [NAME] | 2211088-info@omex | 2211088 | [EMAIL]
[EMAIL] |  | 2211088 | 2211088 | [EMAIL]
22114-[PHONE]-[PHONE]-paci...mirates.net.ae |  | 22114-[PHONE]-[PHONE] | 22114-[PHONE]-[PHONE] | paci...[NAME]
Spreadsheet: ff664ed9-df16-4d0f-a980-d7747e6af5eb
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
TACRO | Test | TACRO | Tacrolimus, Blood | Tacrolimus, B | High-Performance Liquid Chromatography/Tandem Mass Spectrometry (HPLC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions:  1. Draw blood immediately before a schedule dose.  2. Do not centrifuge.  3. Send specimen in original tube. Additional Information:  1. Therapeutic range applies to trough specimens drawn immediately prior to a.m. dose. 2. For specimens sent ambient, sirolimus analysis cannot be performed. If both are ordered, only tacrolimus result will be released. If sirolimus analysis is desired, specimen must be sent refrigerated or frozen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	NA Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 5.0-15.0 ng/mL | Monday through Sunday; 1 p.m. | Same day/1 day | 2 days | 1 | 80197 |  |  |  |  | Rochester
TACRO | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
TACRO | Order Question | DAT8 | Date of last dose |  | Plain Text
TACRO | Order Question | TM71 | Time of last dose |  | Plain Text
TACRO | Order Question | DOSE7 | Dose, mg |  | Plain Text
TACRO | Result | 80783 | Tacrolimus, B | Tacrolimus, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 11253-2 | Tacrolimus:MCnc:Pt:[NAME]:Qn:
TACRO | Result | DAT8 | Date of last dose | Date of last dose | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29742-4 | Date last dose:TmStp:Pt:Dose:Qn:
TACRO | Result | TM71 | Time of last dose | Time of last dose | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29637-6 | Time last dose:TmStp:Pt:Dose:Qn:
TACRO | Result | DOSE7 | Dose, mg | Dose, mg | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32594-4 | Tacrolimus:Mass:Pt:Dose:Qn:
Spreadsheet: jeff_dasovich__14134__Pick Sheet - Week 16
Sheet: Week 16

NFL PICKS OF THE WEEK - 2000
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO: E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 16  - First Game is Saturday @ 9:30 a.m.
 |  | Visitor |  |  |  | Home
Saturday, December 16
 |  | Washington Redskins |  |  |  | Pittsburgh Steelers
 |  | Oakland Raiders |  |  |  | [NAME]
Sunday, December 17
 |  | New England Patriots |  |  |  | Buffalo Bills
 |  | [NAME] |  |  |  | Cincinnati Bengals
 |  | Tennessee Titans |  |  |  | [NAME]
 |  | Denver Broncos |  |  |  | Kansas City Chiefs
 |  | Green Bay Packers |  |  |  | Minnesota Vikings
 |  | Atlanta Falcons |  |  |  | New Orleans Saints
 |  | Detroit Lions |  |  |  | NY Jets
 |  | San Diego Chargers |  |  |  | Carolina Panthers
 |  | Chicago Bears |  |  |  | San Francisco 49er's
 |  | Indianapolis Colts |  |  |  | [NAME]
 |  | Baltimore Ravens |  |  |  | Arizona Cardinals
 |  | NY Giants |  |  |  | Dallas Cowboys
Monday, December 18
 |  | St. Louis Rams |  |  |  | Tampa Bay Buccaneers
Tiebreaker |  |  |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | Philadelphia Eagles
Spreadsheet: 268136d1380458807-search-for-value-and-then-copy-value-in-adjacent-column-example-spreadsheet
Sheet: Sheet1

Case | Data | helper | helper
A | ABCD
B | JFST
B | KDSG
B | KSDH
B | SDJS
A | SJFE
A | KKDS
B | YEST
A | SDJS
A | SDJS
A | SJFE
B | KKDS
A | ITSK
A | KSHD
B | MFSH
B | MCIE
A | TMRW
B | KSHD
A | MFSH
B | MCIE
B | KKDS
A | YEST
A | MFSH
B | MCIE
B | SDJS
A | KSHD
B | MFSH
A | MCIE
B | TMRW
Spreadsheet: 97780d1296857840-reference-lookup-formula-762962_fervorking
Sheet: Summary

Date | 2010-12-01 00:00:00
 | Cat1 |  |  |  |  | Cat2 |  |  |  |  | Cat3 |  |  |  |  | Cat4 |  |  |  |  | Cat5
 | [NAME] | Total | 2010-12-01 00:00:00 | Total |  | [NAME] | Total | 2010-12-01 00:00:00 | Total |  | [NAME] | Total | 2010-12-01 00:00:00 | Total |  | [NAME] | Total | 2010-12-01 00:00:00 | Total |  | [NAME] | Total | 2010-12-01 00:00:00 | Total
Location1 | 2010-12-01 00:00:00 | 290783.83 | 2009-12-01 00:00:00 | 240270.8 |  | 2010-12-01 00:00:00 | 301782.76 | 2009-12-01 00:00:00 | 279596.97 |  | 2010-12-01 00:00:00 | 68344.98 | 2009-12-01 00:00:00 | 62706.27 | 641912 | 2010-12-01 00:00:00 | 0.2278203514417871 | 2009-12-01 00:00:00 | 0.2242737823660965 | 641912 | 2010-12-01 00:00:00 | 76408.86 | 2009-12-01 00:00:00 | 50209.62
 | 2 | 2 | 2 | 2 |  | 3 | 3 | 3 | 3 |  | 4 | 4 | 4 | 4 |  | 5 | 5 | 5 | 5 |  | 6 | 6 | 6 | 6
Location2 | 2010-12-01 00:00:00 | 683873.17 | 2010-12-01 00:00:00 | 637912 |  | 2010-12-01 00:00:00 | 716293.91 | 2010-12-01 00:00:00 | 641912 |  | 2010-12-01 00:00:00 | 208138.91 | 2010-12-01 00:00:00 | 203037 | #N/A | 2010-12-01 00:00:00 | 0.3163003651590872 | 2010-12-01 00:00:00 | 0.3163003651590872 | #N/A | 2010-12-01 00:00:00 | 98183.57 | 2010-12-01 00:00:00 | 97255.42
 | 8 | 8 | 8 | 8 |  | 9 | 9 | 9 | 9 |  | 10 | 10 | 10 | 10 |  | 11 | 11 | 11 | 11 |  | 12 | 12 | 12 | 12
Location3 | 2010-12-01 00:00:00 | 356786.19 | 2010-12-01 00:00:00 | 308540 |  | 2010-12-01 00:00:00 | 361825.31 | 2010-12-01 00:00:00 | 310590 |  | 2010-12-01 00:00:00 | 40133.09 | 2010-12-01 00:00:00 | -5650 | 582183.48 | 2010-12-01 00:00:00 | 0.1109184152982554 | 2010-12-01 00:00:00 | -0.01819118451978493 | 582183.48 | 2010-12-01 00:00:00 | 71132.15 | 2009-12-01 00:00:00 | 48171.47
 | 14 | 14 | 14 | 14 |  | 15 | 15 | 15 | 15 |  | 16 | 16 | 16 | 16 |  | 17 | 17 | 17 | 17 |  | 18 | 18 | 18 | 18
Location99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 582183.48 |  |  |  |  | 582183.48
 | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: phillip_allen__29968__pallen_1023
Sheet: Total w all TP

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NATURAL GAS BASIS POSITIONS
 | 2001-10-22 00:00:00
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 50883d1250460831-allocation-of-inventory-items-allocated-inventory
Sheet: orders

ORDNUMBER | ITEMNO | QTYBACKORD
121222 | 275285000000 | 29
121227 | 275285000000 | 3
121234 | 275285000000 | 9
121246 | 114050000000 | 4
121246 | 192826000000 | 6
121635 | 283165000000 | 0.0833
121642 | 546925000000 | 2
121643 | 114050000000 | 2
121649 | 283165000000 | 0.0833
121654 | 275285000000 | 1
121658 | T701232000000 | 0.1666
121661 | 550015000000 | 30
121661 | 550124000000 | 10
121661 | 553064000000 | 30
121661 | 555325140116 | 21
121661 | 556575000000 | 21
121684 | 310123000000 | 2
Spreadsheet: tracy_geaccone__40404__sharris1101_Wk1l
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
October:  10/01/01 thru 10/31/01 |  |  |  |  |  | 2001-11-01 11:18:07.590000
Plan vs. Forecast |  | October, 2001
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 10.272 | 10.538 | 0.266 |  | New Contracts; Higher rates
West Commodity Revenues |  | 0.853135 | 0.8932929999999999 | 0.04015799999999992
East Demand Revenues |  | 1.044 | 1.228 | 0.1839999999999999 |  | New Contracts
East Commodity Revenues |  | 0.138 | 0.18 | 0.04199999999999993
[NAME] |  | 0.635 | 0.712 | 0.07699999999999996 |  | New Contracts; [NAME] rates
[NAME] Revenues |  | 0.08299999999999996 | 0.06800000000000006 | -0.0149999999999999
[NAME] |  | 0 | 0.005047899999999999 | 0.005047899999999999
Revenue Variance |  | 13.026135 | 13.6243409 | 0.5982058999999982
Fuel Price [NAME] |  | 1.104 | 0.69 | -0.4140000000000001 |  | MTD index price of $2.12 vs. Plan index price of $3.39
Fuel Volume Variance-Unhedged |  | 0 | -0.276 | -0.276
Sales Margin Variance on Unhedged |  | 0 | 0.07 | 0.07
Hedging Adjustment |  | 2.199 | 2.206 | 0.007000000000000117
Other Adjustment |  | 0.002 |  | -0.002
Fuel Variance (Excludes UAF) |  | 3.305 | 2.69 | -0.615
Monthly Stretch |  | 0.838 | 0 | -0.838
Target Adjustment |  | -0.3 | 0 | 0.3
Current Month Margin Variance |  | 16.869135 | 16.3143409 | -0.5547941000000018
Expenses |  | -1.018 | -0.944 | 0.07400000000000007
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.004 | -0.004 | 0
Total Current Month Variance |  | 15.847135 | 15.3673409 | -0.4807941000000018
[NAME] |  | 44.342 | 47.153 | 2.811
2nd Qtr |  | 43.266 | 52.278 | 9.012
1st Qtr |  | 45.571 | 47.784 | 2.213000000000001
October 31, 2001 YTD |  | 149.026135 | 162.5823409 | 13.55620589999998 |  | Includes YTD Target adjustment of ($3.3)
 |  |  |  |  |  | Includes September Actuals
 |  |  |  |  |  | YTD variance decreased due to OBA re-evaluations for August & September
Spreadsheet: 40036d1238356834-countif-sin90-report
Sheet: Matrix

Activity Number | Primary Resolution | Cust Acct Number | Service Duration Days | Prior Order Subtype | Prior Tech Login | Prior Tech Team
1-KKO5J4O | Repair/Replace Pole Mount | 68472696 | 11 | Former Install | ASGA002480 | 402 SUB MATRIX
1-KW32QTQ | IRD Reauthorized | 22314046 | 6 | Upgrade | ASGA002482 | 402 SUB MATRIX
1-KXJEBUN | Cable Replace From IRD | 35765473 | 14 | New Install | ASGA002482 | 402 SUB MATRIX
1-KYO2JY1 | Customer Education Other | 82310064 | 23 | New Install | ASGA002482 | 402 SUB MATRIX
1-L0TP2D4 | DVR 2nd Line Added | 45341485 | 1 | Upgrade | ASGA002482 | 402 SUB MATRIX
1-KPEGX28 | Customer Education Other | 15017413 | 2 | Former Install | ASGA002483 | 402 SUB MATRIX | 6
Spreadsheet: 794481d1662065274-help-calculating-total-hrs-worked-when-meal-out-in-fields-are-left-blank-timesheet-help-august-timesheet4
Sheet: Dominique L.

Month/Year: | August, 2022
Name: | [NAME]
Payrate: | 23
 |  |  | Date | Account | Time In | Meal Out | Meal In | Time Out | Total Hrs | Total Overtime | Notes |  | Total Reg Hrs:
 |  | Pay Period 1 | 2022-08-02 00:00:00 | Theragent | 09:00:00 |  |  | 13:30:00 |  |  | Clean outside labs
 |  |  | 2022-08-03 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 23:00:00 |  |  | Sporklenz CPR 4
 |  |  | 2022-08-04 00:00:00 | Theragent | 09:00:00 | 13:00:00 | 14:00:00 | 17:30:00 |  |  | Clean outside labs, [NAME], Clean windows |  | Total Overtime Hrs:
 |  |  | 2022-08-07 00:00:00 | Theragent | 14:00:00 | 18:00:00 | 19:00:00 | 04:30:00 |  | 5.5 | Water clean CPR1-4, all supporting areas
 |  |  | 2022-08-08 00:00:00 | Theragent | 16:30:00 | 20:00:00 | 21:00:00 | 03:30:00 |  | 1 | [NAME] clean CPR 1-4
 |  |  | 2022-08-09 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 03:00:00 |  | 2 | [NAME] clean supporting areas |  | Total Pay:
 |  |  | 2022-08-10 00:00:00 | Theragent | 16:00:00 | 20:00:00 | 21:00:00 | 09:00:00 |  | 8 | Sporklenz CPR 2-3, all supporting areas, thorough clean glass
 |  |  | 2022-08-11 00:00:00 | Theragent | 19:00:00 | 21:00:00 | 22:00:00 | 10:00:00 |  | 6 | Sporklenz CPR 2-3, all supporting areas, thorough clean glass
 |  |  | 2022-08-13 00:00:00 | Theragent | 11:00:00 | 15:00:00 | 17:00:00 | 21:00:00 |  |  | Clean floors [NAME] CPR 1-4 all supporting areas
 |  |  | 2022-08-15 00:00:00 | Theragent | 11:00am |  |  | 15:30:00 |  |  | Standby
 |  |  |  |  |  |  |  |  | Total Reg Hrs: | Total Overtime Hrs:
 |  |  | 2022-08-13 00:00:00 | UCLA Santa [NAME] | 150
 |  |  | 2022-08-15 00:00:00 | [NAME] | 150
 |  | Pay Period 2
Spreadsheet: 697878d1601579653-calculating-overtime-past-40-hours-work-hours-and-cost-estimate-1-
Sheet: Work Hours and Cost Estimate

People per Shift | 8
Total Man hours | 1500
Regular Rate | 75
OT Rate | 140
 |  |  |  |  |  |  |  |  | Revise formula
Scenario | Hours | RP | Total Hours | OT Factor | OT Hours |  | Calc | Number of Hours | Number of Days | Regular Rate Cost | OT Rate Cost
8x5
8x5+Sat
8x5+Sat/Sun
10x5
10x5+Sat
10x5+Sat/Sun
12x5
12x5+Sat
12x5+Sat/Sun
16x5 CON
16x6 Sat CON
16x7 Sun CON
20x5 CON
20x6 CON
24x5 CON
24x6 CON
 | Need to add overtime hours after regular dayshift
 | 5/6/7 day option 16 hours for sat/sun
Spreadsheet: 883241d1731795139-key-return-sum-of-key-values-in-table-based-on-reference-values-example
Sheet: Sheet1

END | CAT | A | B | C | D | Key
2024-07-06 00:00:00 | 1 | 1 | 2 | 3 | 4 | 1 | A
 | 2 | 1 | 2 | 3 | 4
 | 3 | 1 | 2 | 3 | 4 | Sum
 | 4 | 1 | 2 | 3 | 4 | $2 ([NAME] ?)
 | 5 | 1 | 2 | 3 | 4
 | 6 | 1 | 2 | 3 | 4
 | 7 | 1 | 2 | 3 | 4
 | 1 | 1 | 2 | 3 | 4
 | 2 | 1 | 2 | 3 | 4
 | 3 | 1 | 2 | 3 | 4
 | 4 | 1 | 2 | 3 | 4
 | 5 | 1 | 2 | 3 | 4
 | 6 | 1 | 2 | 3 | 4
 | 7 | 1 | 2 | 3 | 4
Spreadsheet: 26732d1219145819-linking-spreadsheets-summary
Sheet: Sheet1

Payroll | Week/ Month | Paydate | PAYE | Student Loan | PAYE due | [NAME] | [NAME] | Gross Ni | SMP | SMP Rec | SPP | SPP Rec | SAP | SAP Rec
[NAME] | 14 | 2008-07-08 00:00:00 | 7 | 39588 | 39595 | 0 | 839.6 | 839.6 | 308.09 | 572.69 | 0 | 0 | 117.18 | 107.81
[NAME] | 15 | 2008-07-15 00:00:00 | 8 | 39595 | 39603 | 0 | 900.6 | 900.6 | 242.62 | 450.95 | 450.95 | 0 | 23.44 | 21.56
[NAME] | 16 | 2008-07-22 00:00:00 | 9 | 39602 | 39611 | 0 | 1232.2 | 1232.2 | 210.06 | 390.4 | 0 | 0 | 0 | 0
[NAME] | 17 | 2008-07-29 00:00:00 | 10 | 39609 | 39619 | 0 | 1676 | 1676 | 500.73 | 930.69 | 0 | 930.69 | 0 | 0
[NAME] | 18 | 2008-08-05 00:00:00 | 11 | 39616 | 39627 | 0 | 1511.4 | 1511.4 | 454.98 | 845.6800000000001 | 0 | 0 | 0 | 0
WC784 | 14 | 2008-07-08 00:00:00 | 7 | 39588 | 39595 | 14 | 12527.8 | 12541.8 | 7827.04 | 14482.54 | 198.75 | 182.86 | 0 | 0
WC784 | 15 | 2008-07-15 00:00:00 | 8 | 39595 | 39603 | 13 | 11826.4 | 11839.4 | 7399.24 | 13672.01 | 198.75 | 182.84 | 0 | 0
WC784 | 16 | 2008-07-22 00:00:00 | 9 | 39602 | 39611 | 5 | 11131.6 | 11136.6 | 6943.62 | 12842.57 | 198.75 | 182.86 | 0 | 0
WC784 | 17 | 2008-07-29 00:00:00 | 10 | 39609 | 39619 | 8 | 12524.6 | 12532.6 | 7910.48 | 14575.15 | 198.75 | 182.84 | 117.18 | 107.81
WC784 | 18 | 2008-08-05 00:00:00 | 11 | 39616 | 39627 | 3 | 9524.2 | 9527.2 | 6022.95 | 11142.9 | 198.75 | 182.86 | 0 | 0
[NAME] | 14 | 2008-07-11 00:00:00 | 7 | 39591 | 39598 | 0 | 15556.2 | 15556.2 | 9866.55 | 18294.24 | 303.68 | 279.38 | 0 | 0
[NAME] | 15 | 2008-07-18 00:00:00 | 8 | 39598 | 39606 | 0 | 13982.8 | 13982.8 | 8871.03 | 16444.48 | 514.62 | 904.68 | 0 | 904.68
[NAME] | 16 | 2008-07-25 00:00:00 | 9 | 39612 | 39621 | 0 | 12840.8 | 12840.8 | 9460.43 | 15266.06 | 280.26 | 257.84 | 280.26 | 0
[NAME] | 17 | 2008-08-01 00:00:00 | 10 | 39612 | 39622 | 0 | 10518.6 | 10518.6 | 6977.7 | 12920.78 | 0 | 0 | 0 | 0
[NAME] | 18
PC783 | 16 | 2008-07-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MC781 | 4 | 2008-07-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MC782 | 4 | 2008-07-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MC783 | 4 | 2008-07-25 00:00:00 | 0 | Permit No | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 4 | 2008-07-25 00:00:00 | 0 | Permit No | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MC785 | 4 | 2008-07-25 00:00:00 | 0 | Permit No | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  |  | 124 | 554433 | #N/A | 43 | 116592.8 | 116635.8 | 72995.52 | 132831.14 | 2543.26 | 3286.85 | 538.06 | 1141.86
Spreadsheet: 876865d1723579368-need-if-formula-with-a-max-value-tech-commission-sample
Sheet: Sheet1

Order Number | Costed Date | Total Parts | Total Labor | Total Other | Final Component Code | Parts 2nd | Labor 2nd | Parts Avoid | Labor Avoid | Parts Tires | Labor Tires
SWO000007 | 2024-07-16 00:00:00 | 265.35 | 1683 | 10.75 | 11
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: Turfgrass InfoCtr

Turfgrass Information Center
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per search
Displayed result sets (i.e. searches?) | 0 | 15 | 25 | 24 | 58 | 0 | 4 | 77 | 32 | 18 | 12 | 12 |  | 0 | N/A
COUNTER-Compliant?: | No
Spreadsheet: 173861d1344814685-dynaimc-sum-range-sample
Sheet: Summary

Current Month | 2012-08-01 00:00:00
 | Trying to Get | Last Formula
SAAR (sum of May June July) | 520 | 240
I would like the above equation to use the Date in B1 to automatically go back 3 months from that date. So in September, the equation in B3 would take the sum of Aug July & June. Note) I can not re-structure the data
 |  |  | 2012-01-01 00:00:00
 |  |  | 2012-02-01 00:00:00
 |  |  | 2012-03-01 00:00:00
 |  |  | 2012-04-01 00:00:00
 |  |  | 2012-05-01 00:00:00
 |  |  | 2012-06-01 00:00:00
 |  |  | 2012-07-01 00:00:00
 |  |  | 2012-08-01 00:00:00
 |  |  | 2012-09-01 00:00:00
 |  |  | 2012-10-01 00:00:00
 |  |  | 2012-11-01 00:00:00
 |  |  | 2012-12-01 00:00:00