tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 692324d1598278715-allocate-value-on-fifo-basis-book2
Sheet: Sheet1

 | Date | Consumption | Allocation
 |  |  | 5
 | 2020-01-31 00:00:00 | 10 |  |  |  |  | 1
 | 2020-03-01 00:00:00 | -200 |  |  |  |  | 2
 | 2020-03-28 00:00:00 | 100 |  |  |  |  | 3
 | 2020-03-13 00:00:00 | 150 |  |  |  |  | 4
 | 2018-05-01 00:00:00 | -50 |  |  |  |  | 5
 | 2020-01-20 00:00:00 | 0 |  |  |  |  | 6
 | 2020-02-03 00:00:00 | 15 |  |  |  |  | 7
 | 2020-02-29 00:00:00 | 50 |  |  |  |  | 8
 | 2020-04-07 00:00:00 | 400 |  |  |  |  | 9
 | 2020-04-05 00:00:00 | 600 |  |  |  |  | 10
 | 2020-01-26 00:00:00 | 0 |  |  |  |  | 11
 | 2020-02-22 00:00:00 | -5 |  |  |  |  | 12
 | 2020-03-01 00:00:00 | -800 |  |  |  |  | 13
 | 2020-03-28 00:00:00 | 300 |  |  |  |  | 14
Spreadsheet: 727975d1618237032-returning-outstanding-invoice-amount-for-partial-payments-pr-supplier-accounts-payable-summary
Sheet: (Accounts-Payable) Bill Entries

ABC Enterprise Ltd.
Date | [NAME] | Invoice No. | Due Date | [NAME] | Particulars | Vendor PO
2020-12-01 00:00:00 | Ashik Traders Inc. | 10001 |  | 15084 | [NAME] for the month of December - 2020
2021-01-01 00:00:00 | Ashik Traders Inc. | 10002 |  | 80315 | [NAME] for the month of January - 2021
2021-02-01 00:00:00 | Ashik Traders Inc. | 10003 |  | 54775 | [NAME] for the month of February - 2021
Spreadsheet: 50459d1249918219-i-want-to-calculate-a-result-only-if-a-cell-in-a-previous-worksheet-is-populated-holidays-2009-staff-test
Sheet: June

 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
Name | Entitlement | Total Holiday's Used | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | Full days Booked | 1/2 Days Booked | Holiday's Used | Lateness | Sickness Absence (Current Months Total) | Sickness Absence (Days - Rolling 12 Months) | Sickness Absence Periods (Current Months Total) | Sickness Absence (Periods - Rolling 12 Months) | Bradford Index Score (Rolling 12 Months)
A.N.Other | 25 | 21.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S 1 | S 1 | S 1 |  |  | S 1 | S 1 | S 1 | S 1 | S 1 |  |  | S 1 | S 1 |  |  | 1 | 0 | 10 | 31 | 1 | 4 | 496
 |  |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0
S 1 | L
S 2 | H
S 3 | 0.5
S 4 | AA
S 5 | UA
S 6 | TR
Spreadsheet: 738837d1625263959-xlookup-substitution-in-excel-2019-ofline-xlookup-sample
Sheet: Product list

Product No.: | Short Desc.: | Product Code: | Weight: |  | Long desc.: | Alt. Product Code:
2248 | Apple | ABZ | 1
4615 | Pear | CDA | 2
5698 | Grape | OMG | 3
2248
4615
2248
2248
Spreadsheet: 719159d1613529919-match-search-and-return-donation-tracker
Sheet: Itemized

 | ITEMIZED DONATIONS LIST (2021) |  |  |  |  |  |  |  |  |  | SCAN BARCODE
 | ID | DATE | ITEM NUMBER | UPC | [NAME] | SOURCE | VALUE | QUANTITY | TOTAL VALUE |  | LOOKUP ITEM
 | 21-01 | 2021-02-11 00:00:00 | 14-020-010 |  | SRB FLAG RWB PATCH HAT, BLACK | Black Rifle Coffee | 26.99 | 3
 | 21-01 | 2021-02-11 00:00:00 | 23-031-30Z | 810019261176 | SRB FLAG TUMBLER, STAINLESS, M BLK, 30Z | Black Rifle Coffee | 33.95 | 3
 | 21-01 | 2021-02-11 00:00:00 | 28-023-010 | 810019269653 | WOOBIE BLANKET-BDU | Black Rifle Coffee | 44.99 | 1
 | 21-01 | 2021-02-11 00:00:00 | 28-024-010 | 810019269660 | WOOBIE BLANKET, FROGSKIN | Black Rifle Coffee | 44.99 | 1 |  |  | RUNNING TOTALS
 | 21-01 | 2021-02-11 00:00:00 | 28-025-010 | 810019269677 | [NAME], MIDNIGHT CAMO | Black Rifle Coffee | 44.99 | 1 |  |  | LINES REMAINING | ITEMS RECEIVED | VALUE
 | 21-01 | 2021-02-11 00:00:00 | 30-000-12G | 857849006027 | AK-47, GROUND COFFEE, 12OZ | Black Rifle Coffee | 14.99 | 10
 | 21-01 | 2021-02-11 00:00:00 | 30-000-5PG | 818890026440 | AK-47, GROUND COFFEE, 5 LB | Black Rifle Coffee | 74.99 | 1 |  |  | ID's REMAINING | NUMBER OF DONATIONS | TO CAP
 | 21-01 | 2021-02-11 00:00:00 | 30-003-12G | 857849006089 | SILENCER SMOOTH, GROUND COFFEE 12 OZ | Black Rifle Coffee | 13.99 | 10
 | 21-01 | 2021-02-11 00:00:00 | 30-003-5PG | 818890026426 | SILENCER SMOOTH, GROUND COFFEE, 5 LB | Black Rifle Coffee | 74.99 | 1
 | 21-01 | 2021-02-11 00:00:00 | 30-006-12G | 857849006003 | JUST BLACK, GROUND COFFEE, 12 OZ | Black Rifle Coffee | 12.99 | 10 |  |  | DONATIONS BY MONTH (2021)
 | 21-01 | 2021-02-11 00:00:00 | 30-009-5PG | 818890026433 | BEYOND BLACK, GROUND COFFEE, 5LB | Black Rifle Coffee | 74.99 | 1 |  |  | MONTH | NUMBER OF DONATIONS | VALUE
 | 21-01 | 2021-02-11 00:00:00 | 30-013-12G | 857849006744 | BLACKBEARDS [NAME], GROUND COFFEE, 12 OZ | Black Rifle Coffee | 14.99 | 10 |  |  | January
 | 21-02 | 2021-02-15 00:00:00 |  |  | $5 E-Gift Cards | Fire dept. Coffee | 5 | 3 |  |  | February
 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  | DONATIONS BY ORGANIZATION
 |  |  |  |  |  |  |  |  |  |  | ORGANIZATION | ITEMS DONATED | VALUE
 |  |  |  |  |  |  |  |  |  |  | Black Rifle Coffee
 |  |  |  |  |  |  |  |  |  |  | Fire dept. Coffee
 |  |  |  |  |  |  |  |  |  |  | Level Zero
 |  |  |  |  |  |  |  |  |  |  | PRIVATE
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | HIGHEST VALUE | DONATED BY | ID
Spreadsheet: 685351d1593941179-lookup-doesn-t-compute-correct-higher-values-2020-07-05-oeldere-oulyas-685343d1593939708-lookup-doesn-t-compute-correct-higher-values-wron
Sheet: Tabelle1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | Aim to get → | First highest value from A4:M4 | Second highest value A4:M4 | Third highest value A4:M4
2 | 0 | 1 | 1 | 2 | 2 | 1 | 3 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Following figures are correct in this table this table it would be correct | 0 | 12 | 4
Spreadsheet: 249187d1373459941-help-with-day-sheet-for-roster-mockingbird
Sheet: Day sheet

2013-05-06 00:00:00
05:00:00 |  | 05:30:00 |  | 06:00:00 |  | 06:30:00 |  | 07:00:00 |  | 07:30:00 |  | 08:00:00 |  | 08:30:00 |  | 09:00:00 |  | 09:30:00 |  | 10:00:00 |  | 10:30:00 |  | 11:00:00 |  | 11:30:00 |  | 12:00:00 |  | 12:30:00 |  | 13:00:00 |  | 13:30:00 |  | 14:00:00 |  | 14:30:00 |  | 15:00:00 |  | 15:30:00 |  | 16:00:00 |  | 16:30:00 |  | 17:00:00 |  | 17:30:00 |  | 18:00:00 |  | 18:30:00 |  | 19:00:00 |  | 19:30:00 |  | 20:00:00 |  | 20:30:00 |  | 21:00:00 |  | 21:30:00 |  | 22:00:00 |  | 22:30:00
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Henrietta Hope |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -316 | -260
2 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -544 | -260
3 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -307 | -260
4 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -634 | -260
5 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -440 | -260
6 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -143 | -260
7 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -372 | -260
8 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1467 | -260
9 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -54 | -260
10 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -671 | -260
11 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1814 | -260
12 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -1 | -260
13 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -300 | -260
14 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -490 | -319
15 | -125 | -125 | -1 | -1 | -90 | -90 | -2 | -2 | -40 | -40 | -328 | -319
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 28367.49
2001-12-15 00:00:00
CBS Volume
 |  |  | 10205
Spreadsheet: 723905d1615941015-need-help-with-filtering-formula-temp1
Sheet: Bank Info

Name | Account Type | Account # | Description
Arvest | Checking | 8877788 | Building Fund
Arvest | Checking | 58585858 | Main
Arvest | Savings | 77788777 | Main
Arvest | Savings | 7770000 | Youth
BearState | CD | 123654789 | Investment
CityBank | Checking | 9874562310 | Other Checking
FirstBank | Checking | 6845846574 | Youth
This sheet is used for the Bank Info that the DataFilter sheet referances.
Spreadsheet: 99093d1297857301-conditional-formatting-following-a-drop-down-box-entry-test-sales
Sheet: Jan-Feb-March Deals

Initial Quote Date | Call Back Date | Renewal Date | Business Name | Contact | Quote Ref | Deal Value | Est Profit | Status | Notes
11/02/2011 |  |  | iTELICA MANAGING TECHNOLOGY |  |  | 2400 |  | Ongoing - 50/50 Interest |  |  |  |  | Won - Dean
11/02/2011 |  |  | iTELICA MANAGING TECHNOLOGY |  |  | 23704.8 |  | Won - Dean |  |  |  |  | Won - Eddie
09/02/2011 |  |  | Armada Finance |  |  | 8744.4 |  | Lost - To Competitor |  |  |  |  | Lost - To Competitor
08/02/2011 |  |  | Wow Internet Ltd |  |  | 2090.4 |  | Ongoing - Interested in Booking an Appointment |  |  |  |  | Lost - Purchased Equipment
08/02/2011 |  |  | CREATIVE & COMMERCIAL COMMUNICATIONS LTD |  |  | 4653.6 |  | Ongoing - Information Sent |  |  |  |  | Lost - Not Interested / Happy with Existing Support
 |  |  |  |  |  |  |  |  |  |  |  |  | Lost - Unable to Obtain Finance
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - Interested in Booking an Appointment
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - Awaiting Current Renewal Date
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - 50/50 Interest
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - Information Sent
Spreadsheet: 5a612b5c-6860-4d37-a2b2-ff1a080da536
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5133 | 32688 | [NAME] | Burke | NZL | 0 | 00:37:49 | 00:00:00 | 01:06:41 | 00:00:00 | 00:19:04 | 1 | [NAME]
5133 | 6072 | [NAME] | Bryant | NZL | 51 | 00:38:00 | 00:00:00 | 01:14:19 | 00:00:00 | [NAME] | 2 | [NAME]
Spreadsheet: 804121d1667905258-countifs-with-duplicates-excel-challenge
Sheet: Distribution

 | Current Month |  |  |  |  | 2023-01-01 00:00:00
 | 2023-02-01 00:00:00 |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  | 2023-03-01 00:00:00
 | [NAME] for last month |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  | 2023-05-01 00:00:00
 | Sales |  |  |  |  | 2023-06-01 00:00:00
 | No. Of Customers |  |  |  |  | 2023-07-01 00:00:00
 | Avg. Order quantity |  |  |  |  | 2023-08-01 00:00:00
 | Avg. Basket size |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  | 2023-12-01 00:00:00
Spreadsheet: 42101d1240647535-alerts-when-previously-entered-text-with-certain-properties-is-entered-another-time-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | done but late |  |  |  |  | Users: | [NAME]
 |  |  |  |  |  |  |  |  | did not finnished |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | still have unfinished task |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Uncompleted tasks | completed tasks | Start date | End date | Task completed | task | end of task |  |  |  |  |  |  |  | [NAME]
[NAME] | 0 | 1 | 2009-01-01 00:00:00 | 2009-03-01 00:00:00 | Yes | reach sky | 2009-03-01 00:00:00 |  |  |  |  |  |  |  |  | start date | end date
[NAME] | 0 | 1 | 2009-01-17 00:00:00 | 2009-02-01 00:00:00 | Yes | reach sky | 2009-03-01 00:00:00 |  |  |  |  |  |  | tasks: | reach sky | 2009-01-01 00:00:00 | 2009-03-01 00:00:00
[NAME] | 0 | 1 | 2009-01-22 00:00:00 | 2009-03-06 00:00:00 | Yes | reach sky | 2009-03-01 00:00:00 |  |  |  |  |  |  |  | find formula | 2009-03-22 00:00:00 | 2009-05-25 00:00:00
[NAME] | 1 | 0 | 2009-01-27 00:00:00 |  | No | reach sky | 2009-03-01 00:00:00 |  |  |  |  |  |  |  | finish excel | 2009-04-01 00:00:00 | 2009-06-22 00:00:00
[NAME] | 0 | 1 | 2009-03-22 00:00:00 | 2009-05-25 00:00:00 | Yes | find formula | 2009-05-25 00:00:00
[NAME] | 0 | 2 | 2009-03-22 00:00:00 | 2009-05-27 00:00:00 | Yes | find formula | 2009-05-25 00:00:00
[NAME] | 2 | 0 | 2009-04-01 00:00:00 |  | No | finish excel | 2009-06-22 00:00:00
[NAME] | 0 | 3 | 2009-04-01 00:00:00 | 2009-06-01 00:00:00 | Yes | finish excel | 2009-06-22 00:00:00
[NAME] | 0 | 2 | 2009-04-02 00:00:00 | 2009-06-10 00:00:00 | Yes | finish excel | 2009-06-22 00:00:00
[NAME] | 1 | 1 | 2009-04-06 00:00:00 |  | No | finish excel | 2009-06-22 00:00:00
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0 | 0 |  |  |  |  | #N/A
 | 0
Spreadsheet: 729335d1619025087-indirect-data-validation-problem-with-expanding-named-ranges-indirect-data-vailidation-example-sheet
Sheet: Sheet1

Corrugated | Carton | 0200 stitched carton | B150WT(150S/C) |  | Category | Corrugated | Carton | Grade
 |  |  |  |  | Corrugated | Carton | 0200 glued carton | B125KT
 |  |  |  |  | Tape/Stretch film | Fitment | 0201 glued carton | B125LT
 |  |  |  |  | Plastics/Strapping |  | 0203 glued carton | B125TT
 |  |  |  |  | Voidfill/Labels |  | 0300 glued carton | B125VT
 |  |  |  |  | Tooling/Equipment |  | 0200 stitched carton | B125WT
 |  |  |  |  | Sheetboard/Paper |  | 0201 stitched carton | B150KT
 |  |  |  |  |  |  | 0203 stitched carton | B150KT(150S/C)
 |  |  |  |  |  |  | 0300 stitched carton | B150LT
 |  |  |  |  |  |  |  | B150LT(150S/C)
 |  |  |  |  |  |  |  | B150TT
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | B150WT
 |  |  |  |  |  |  |  | B150WT(150FL)
 |  |  |  |  |  |  |  | B150WT(150S/C)
 |  |  |  |  |  |  |  | B180W200T
 |  |  |  |  |  |  |  | B180W200T(150S/C)
 |  |  |  |  |  |  |  | B200KT
 |  |  |  |  |  |  |  | B200KT(150S/C)
Spreadsheet: 390543d1429685813-dates-and-months-dates-and-months
Sheet: Sheet1

2015-01-01 00:00:00
Spreadsheet: 411758d1438721184-mandays-calculation-copy-of-mandays
Sheet: Sheet1

 |  |  | 2015-08-01 00:00:00 | 2015-08-02 00:00:00 | 2015-08-03 00:00:00 | 2015-08-04 00:00:00 | 2015-08-05 00:00:00 | 2015-08-06 00:00:00 | 2015-08-07 00:00:00 | 2015-08-08 00:00:00 | 2015-08-09 00:00:00 | 2015-08-10 00:00:00 |  |  | ABC |  |  | DEF |  |  | SAME FOR ALL PROJECTS
Name | Department | Project |  |  |  |  |  |  |  |  |  |  |  | ABC-P | ABC-A | ABC-0.5 | DEF-P | DEF-A | DEF-0.5 | XYZ-P | XYZ-A | XYZ-0.5
sachin | animation | ABC | ABC-P |  | ABC-A |  | ABC-0.5
rahul | comp | DEF |  | DEF-P |  |  | DEF-A |  | DEF-0.5
virat | light | XYZ | XYZ-P |  | XYZ-A
 |  |  | P | A | 0.5
 | project | dept
 |  | Animation | 1 | 1 | 1
 | ABC | comp | 0 | 0 | 0
 |  | lighting | 0 | 0 | 0
 |  | Animation | 0 | 0 | 0
 | DEF | comp | 1 | 1 | 1
 |  | lighting | 0 | 0 | 0
 |  | Animation | 0 | 0 | 0
 | XYZ | comp | 0 | 0 | 0
 |  | lighting | 1 | 1 | 1
Spreadsheet: 126958d1320080675-how-to-make-calculated-date-not-end-on-weekend-date-test-file
Sheet: Sheet1

Start day and time | Project time in days | Completion date and time
2011-11-03 07:49:54 | 1.49988866222 | 2011-11-04 19:49:44
2011-11-03 13:49:44 | 0.24988886222 | 2011-11-03 19:49:35
2011-11-03 16:49:35 | 0.12488888222 | 2011-11-03 19:49:25
2011-11-04 04:49:25 | 0.49988882222 | 2011-11-04 16:49:16
2011-11-04 09:49:16 | 0.20822220222 | 2011-11-04 14:49:06
2011-11-04 12:49:06 | 0.12488888222 | 2011-11-04 15:48:56
2011-11-04 15:48:56 | 0.12488888222 | 2011-11-04 18:48:47
2011-11-04 23:48:47 | 0.5 | 2011-11-05 11:48:47
2011-11-05 07:48:37 | 0.33322218222 | 2011-11-05 15:48:28
Spreadsheet: 718895d1613407526-descriptive-statistics-updated-results-1-
Sheet: Regression Analysis

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.05468655999297216
R Square | 0.002990619843864943
Adjusted R Square | -0.1216355526756519
Standard Error | 0.8123685065837409
Observations | 10
ANOVA
 | df | SS | MS | F | [NAME]
Regression | 1 | 0.01583646008722006 | 0.01583646008722006 | 0.02399672382939147 | 0.880730266952221
Residual | 8 | 5.27954072391278 | 0.6599425904890975
Total | 9 | 5.295377184
 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Intercept | 0.8255134321166125 | 0.784792148816257 | 1.051887985069394 | 0.3235835008454259 | -0.9842205083294403 | 2.635247372562665 | -0.9842205083294403 | 2.635247372562665
PSS | -0.004367811107095532 | 0.02819602400647366 | -0.1549087596922426 | 0.8807302669522272 | -0.06938795906233976 | 0.0606523368481487 | -0.06938795906233976 | 0.0606523368481487
Spreadsheet: 1c937957-d09f-4953-8f00-f9811e958dc1
Sheet: Sheet1

HFMEA™ Step 1. Room Preparation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
HFMEA™ Step 4 - Hazard Analysis |  |  |  |  |  |  |  |  |  |  | HFMEA™ Step 5 - Identify Actions and Outcomes
Failure Mode:            First evaluate failure mode  before determining potential causes |  | Potential Causes |  | Scoring |  |  | Decision Tree Analysis |  |  |  | Action Type (Control, Accept, Eliminate) | Actions or Rationale for Stopping | Outcome Measure | Person Responsible | Management Concurrence
 |  |  |  | Severity | Probability | [NAME] | Single Point Weakness? | Existing Control Measure? | Detectability | Proceed?
Spreadsheet: 757778d1638455383-filter-formula-over-multiple-sheets-permit-register-gk
Sheet: Invoice

ABC Job Number | Address | Description | Client | Permit  Number | BP INVOICE | [NAME]
 | Address 1 | Description 1 | Client 1 | 001/001/001 | INV READY | INV READY
ABC-21002 | Address 2 | Description 2 | Client 2 | 001/001/002 |  | INV READY
ABC-21003 | Address 3 | Description 3 | Client 3 | 001/001/003 | INV READY
ABC-21004 | Address 4 | Description 4 | Client 4 | 001/001/004 | INV READY
ABC-21006 | Address 6 | Description 6 | Client 6 | 001/001/006 | INV READY
ABC-21008 | Address 8 | Description 8 | Client 8 | 001/001/008 | N/A | INV READY
ABC-21009 | Address 9 | Description 9 | Client 9 | 001/001/009 | - | INV READY
Spreadsheet: 140665d1328854550-splitting-amount-into-individual-cells-starting-from-the-right-copy-of-copy-of-sample-2
Sheet: Sheet1 (2)

 | this is what mid and text to column does
 | 98765412 |  | 9 | 8 | 7 | 6 | 5 | 4 | 1 | 2 | 0 | 0
 | 1678987456 |  | 1 | 6 | 7 | 8 | 9 | 8 | 7 | 4 | 5 | 6 | 0 | 0
 | 1 |  | 1 | 0 | 0
 | 100 |  | 1 | 0 | 0 | 0 | 0
 | 10000671 |  | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 1 | 0 | 0
 | this is what im trying to accomplish
 | 98765412 |  |  |  | 9 | 8 | 7 | 6 | 5 | 4 | 1 | 2 | 0 | 0
 | 1678987456 |  | 1 | 6 | 7 | 8 | 9 | 8 | 7 | 4 | 5 | 6 | 0 | 0
 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0
 | 100 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0
 | 10000671 |  |  |  | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 1 | 0 | 0
Spreadsheet: 707346d1607193160-indirect-using-two-workbooks-sample
Sheet: Unique List

 | ID | First State Japan | First State China | [NAME] |  | ID | Unique List |  |  | ID | First State Japan | First State China | [NAME] |  | ID | Unique List
 | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3 |  |  |  | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5 |  |  |  | 5 |  |  |  |  | 5
 | 6 |  |  |  |  | 6 |  |  |  | 6 |  |  |  |  | 6
 | 7 |  |  |  |  | 7 |  |  |  | 7 |  |  |  |  | 7
 | 8 |  |  |  |  | 8 |  |  |  | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9 |  |  |  | 9 |  |  |  |  | 9
 | 10 |  |  |  |  | 10 |  |  |  | 10 |  |  |  |  | 10
 | 11 |  |  |  |  | 11 |  |  |  | 11 |  |  |  |  | 11
 | 12 |  |  |  |  | 12 |  |  |  | 12 |  |  |  |  | 12
 | 13 |  |  |  |  | 13 |  |  |  | 13 |  |  |  |  | 13
 | 14 |  |  |  |  | 14 |  |  |  | 14 |  |  |  |  | 14
 | 15 |  |  |  |  | 15 |  |  |  | 15 |  |  |  |  | 15
 | 16 |  |  |  |  | 16 |  |  |  | 16 |  |  |  |  | 16
 | 17 |  |  |  |  | 17 |  |  |  | 17 |  |  |  |  | 17
 | 18 |  |  |  |  | 18 |  |  |  | 18 |  |  |  |  | 18
 | 19 |  |  |  |  | 19 |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  | 20 |  |  |  |  |  |  |  |  | 20
 | 21 |  |  |  |  | 21
 | 22 |  |  |  |  | 22
 | 23 |  |  |  |  | 23
 | 24 |  |  |  |  | 24
 | 25 |  |  |  |  | 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
 |  |  |  |  |  | 70
 |  |  |  |  |  | 71
 |  |  |  |  |  | 72
 |  |  |  |  |  | 73
 |  |  |  |  |  | 74
 |  |  |  |  |  | 75
 |  |  |  |  |  | 76
 |  |  |  |  |  | 77
 |  |  |  |  |  | 78
 |  |  |  |  |  | 79
 |  |  |  |  |  | 80
 |  |  |  |  |  | 81
 |  |  |  |  |  | 82
 |  |  |  |  |  | 83
 |  |  |  |  |  | 84
 |  |  |  |  |  | 85
 |  |  |  |  |  | 86
 |  |  |  |  |  | 87
 |  |  |  |  |  | 88
 |  |  |  |  |  | 89
 |  |  |  |  |  | 90
 |  |  |  |  |  | 91
 |  |  |  |  |  | 92
 |  |  |  |  |  | 93
 |  |  |  |  |  | 94
 |  |  |  |  |  | 95
 |  |  |  |  |  | 96
 |  |  |  |  |  | 97
 |  |  |  |  |  | 98
 |  |  |  |  |  | 99
 |  |  |  |  |  | 100