tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469a37fd-8a1c-425e-8dba-c0d86d4134fd
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
0 | Kuncipálová | Hana | 0 | 0 | 1 | 1 | 0 | 0 | 22 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 7 | 17
0 | Vokounová | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -1 | 1
0 | Maršíková | [NAME] | 0 | 0 | 5 | 5 | 3 | 3 | 7 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 18 | 23
0 | Vondrysová | Eliška | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 8
0 | [NAME] | Lucie | 0 | 0 | 2 | 2 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 6
0 | Malá | Eliška | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | -1 | 2
0 | Plechatá | Tereza | 0 | 0 | 3 | 3 | 0 | 0 | 10 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 5 | 12
 |  |  |  |  | 13 | 13 | 5 | 5 | 43 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 35 | 69
 |  |  |  |  | 100% |  | 100% |  | 65%
Spreadsheet: 216394d1361754326-returning-multiple-results-into-different-columns-from-a-master-list-return-multiple-values-in-columns
Sheet: Overall Results Page

Number | Catagory | Name | Search Terms | Task Specific Seach Term | Relevant | Document Names | Date
1 | A | Type of Name 1
 |  |  | Search Term 1
 |  |  |  |  | yes | Returned Result 1 | any
 |  |  |  |  |  | Returned Result 2 | any |  | The Document Names of all results that are deemed relevant need to be returned into their correlating column on the Relation page
 |  |  |  |  |  | Returned Result 3 | any
 |  |  |  |  |  | Returned Result 4 | any
 |  |  |  |  | yes | Returned Result 5 | any
 |  |  |  |  |  | Returned Result 6 | any
 |  |  |  |  |  | Returned Result 7 | any
 |  |  | Search Term 2
 |  |  |  |  | yes | Returned Result 8 | any
 |  |  |  |  |  | Returned Result 9 | any
 |  |  |  |  |  | Returned Result 10 | any
 |  |  |  |  | yes | Returned Result 11 | any
 |  |  |  |  |  | Returned Result 12 | any
2 | A | Type of Name 2
 |  |  | Search Term 2
 |  |  |  |  |  | Returned Result 8 | any
 |  |  |  |  | yes | Returned Result 9 | any
 |  |  |  |  |  | Returned Result 10 | any
 |  |  |  |  | yes | Returned Result 11 | any
 |  |  |  |  |  | Returned Result 12 | any
 |  |  | Search Term 3
 |  |  |  |  | yes | Returned Result 13 | any
 |  |  |  |  | yes | Returned Result 14 | any
 |  |  |  |  | yes | Returned Result 15 | any
 |  |  |  |  |  | Returned Result 16 | any
 |  |  |  |  |  | Returned Result 17 | any
3 | B | Type of Name 3
 |  |  | Search Term 4
 |  |  |  |  | yes | Returned Result 18 | any
 |  |  |  |  | yes | Returned Result 19 | any
 |  |  |  |  |  | Returned Result 20 | any
 |  |  | Search Term 5
 |  |  |  |  | yes | Returned Result 21 | any
 |  |  |  |  |  | Returned Result 22 | any
 |  |  |  |  | yes | Returned Result 23 | any
 |  |  |  |  |  | Returned Result 24 | any
 |  |  |  |  | yes | Returned Result 25 | any
Spreadsheet: 762e53f1-5796-4d89-811b-fe06f4c334d5
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Administrative Applications | 1 | Provide user training | None | -- Pick One -- | 1.1.r1 | Class setup | OneTime | 25000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 3 | Provide current documentation | None | -- Pick One -- | 1.2.r1 | Documentation Specialist | OnGoing | 40000 | 0 | 40000 | 0 | 40000 | 0 | 0 | 0
Administrative Applications | 2 | Publicize provided opportunities | None | -- Pick One --
Administrative Applications | 4 | Permissions maintenance | None | -- Pick One --
Administrative Applications | 2 | Implement structured project management | None | -- Pick One --
Administrative Applications | 3 | Assistive technology | None | -- Pick One -- | 2.2.r1 | Project Database | OneTime | 350 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 1 | Staff development | None | -- Pick One --
Administrative Applications | 1 | Reclass UL Position | None | -- Pick One --
Spreadsheet: 841516d1693696593-using-sumproduct-to-return-values-based-on-criteria-when-date-filter-changes-excel-formula-09-01-2023-bvj-
Sheet: MM Cases

Case Owner | Type of Request | Status | Date/Time Opened | Date/Time Closed | # of Days to [NAME] | Month | Year
[NAME] | Web Support/SCT | Completed | 2022-08-01 12:35:00 | 2022-08-01 12:35:00
[NAME] | Web Support/SCT | Completed | 2022-08-04 09:33:00 | 2022-08-04 10:08:00
[NAME] | Account Creation | Completed | 2022-07-06 16:26:00
[NAME] | Account Revision/Updates | Completed | 2023-02-20 14:45:00 | 2023-02-20 16:14:00
[NAME] | Account Revision/Updates | Completed | 2023-01-09 13:56:00 | 2023-01-11 15:56:00
[NAME] | Account Creation | Completed | 2023-02-21 12:31:00 | 2023-02-21 16:21:00
[NAME] | Account Creation | Completed | 2023-01-18 13:08:00 | 2023-01-24 16:37:00
[NAME] | Account Creation | Completed | 2023-02-21 12:30:00 | 2023-02-21 16:30:00
[NAME] | Account Creation | Completed | 2022-07-06 16:26:00
[NAME] | Account Creation | Completed | 2022-07-06 16:26:00
[NAME] | Account Creation | Completed | 2022-07-11 08:18:00
[NAME] | Account Creation | Completed | 2022-08-31 11:25:00 | 2022-09-19 08:34:00
[NAME] | Account Creation | Completed | 2023-07-07 07:03:00
[NAME] | Web Support/SCT | Completed | 2022-08-01 12:35:00 | 2022-08-01 12:35:00
[NAME] | Web Support/SCT | Completed | 2022-08-04 09:33:00 | 2022-08-04 10:08:00
[NAME] | Account Revision/Updates | Completed | 2022-07-18 08:27:00
[NAME] | Account Revision/Updates | Completed | 2023-02-20 14:45:00 | 2023-02-20 16:14:00
[NAME] | Account Revision/Updates | Completed | 2023-01-09 13:56:00 | 2023-01-11 15:56:00
[NAME] | Account Creation | Completed | 2023-02-21 12:31:00 | 2023-02-21 16:21:00
[NAME] | Account Creation | Completed | 2023-01-18 13:08:00 | 2023-01-24 16:37:00
WholWorth | Account Revision/Updates | Completed | 2022-12-15 13:45:00.005000 | 2023-01-25 16:37:00
[NAME] | Account Creation | Completed | 2022-08-31 11:25:00 | 2022-09-19 08:34:00
[NAME] | Account Creation | Completed | 2022-07-05 08:58:00
[NAME] | Web Support/SCT | Completed | 2022-08-01 12:35:00 | 2022-08-01 12:35:00
[NAME] | Web Support/SCT | Completed | 2022-08-04 09:33:00 | 2022-08-04 10:08:00
[NAME] | Account Creation | Completed | 2022-07-05 08:58:00
[NAME] | Account Revision/Updates | Completed | 2023-02-20 14:45:00 | 2023-02-20 16:14:00
[NAME] | Account Revision/Updates | Completed | 2023-01-09 13:56:00 | 2023-01-11 15:56:00
Spreadsheet: 741640d1627222511-need-help-with-inventory-of-raw-material-items-example-sheet
Sheet: Sheet1

Purchase Date | Raw Material | [NAME] | Quantity/kg | Cumulative/Kg | RM Qnty Used | RM Remain | Exceed
2021-04-10 00:00:00 | Sugar | S1208U | 200 |  | 202
2021-06-17 00:00:00 | Sugar | S1276U | 50 |  | 54
2021-07-02 00:00:00 | Sugar | S1291U | 50 |  | 49
2021-07-12 00:00:00 | Sugar | S1301U | 100 |  | 95
Spreadsheet: 849869d1700238092-consolidate-table-with-array-formulas-testconsolidatetableefnov23
Sheet: Sheet1

 |  | Project Month | Ref Number | Commodity | Value |  | Project Month | Ref Number | Commodity | Value |  | Project Month | Ref Number | Commodity | Sum of Value
 |  | 1 | 100552 | Beans | 5000 |  |  | 100552 | Beans |  |  | 1 | 100552 | Beans | 5000
 |  | 1 | 100589 | Corn | 12000 |  | 1 | 100589 | Corn | 12000 |  |  | 100566 | Oil | 40
 |  | 1 | 110170 | Emergncy Fd | 380 |  | 1 | 110170 | Emergncy Fd | 380 |  |  | 100589 | Corn | 12000
 |  | 1 | 100566 | Oil | 40 |  | 1 | 100566 | Oil | 40 |  |  | 110170 | Emergncy Fd | 380
 |  | 2 | 100552 | Beans | 940 |  | 2 | 100552 | Beans | 1460 |  | 2 | 100552 | Beans | 1460
 |  | 2 | 100605 | Bulgur | 2000 |  | 2 | 100605 | Bulgur | 2000 |  |  | 100566 | Oil | 150
 |  | 2 | 110472 | Corn-Soy Blend | 90 |  | 2 | 110472 | Corn-Soy Blend | 90 |  |  | 100605 | Bulgur | 2000
 |  | 2 | 110452 | Emergency Fd | 90 |  | 2 | 110452 | Emergency Fd | 90 |  |  | 110452 | Emergency Fd | 90
 |  | 2 | 100552 | Beans | 520 |  | 2 | 100566 | Oil | 150 |  |  | 110472 | Corn-Soy Blend | 90
 |  | 2 | 100566 | Oil | 150 |  | 3 | 100553 | Beans | 850 |  | 3 | 100553 | Beans | 850
 |  | 3 | 100553 | Beans | 850 |  | 3 | 100576 | Corn | 2000 |  |  | 100566 | Oil | 400
 |  | 3 | 100576 | Corn | 2000 |  | 3 | 110170 | Emergncy Fd | 120 |  |  | 100576 | Corn | 2000
 |  | 3 | 110170 | Emergncy Fd | 120 |  | 3 | 100566 | Oil | 400 |  |  | 110170 | Emergncy Fd | 120
 |  | 3 | 100566 | Oil | 400 |  | 4 | 100552 | Beans | 1200 |  | 4 | 100552 | Beans | 1200
 |  | 4 | 100552 | Beans | 1200 |  | 4 | 100589 | Corn | 250 |  |  | 100566 | Oil | 630
 |  | 4 | 100589 | Corn | 250 |  | 4 | 110170 | Emergncy Fd | 380 |  |  | 100589 | Corn | 250
 |  | 4 | 110170 | Emergncy Fd | 380 |  | 4 | 110472 | Corn-Soy Blend | 20 |  |  | 110170 | Emergncy Fd | 380
 |  | 4 | 110472 | Corn-Soy Blend | 20 |  | 4 | 100566 | Oil | 630 |  |  | 110472 | Corn-Soy Blend | 20
 |  | 4 | 100566 | Oil | 40 |  | 5 | 100552 | Beans | 900 |  | 5 | 100552 | Beans | 900
 |  | 4 | 100566 | Oil | 590 |  | 5 | 100589 | Corn | 40 |  |  | 100566 | Oil | 1200
 |  | 5 | 100552 | Beans | 900 |  | 5 | 110170 | Emergncy Fd | 500 |  |  | 100589 | Corn | 40
 |  | 5 | 100589 | Corn | 40 |  | 5 | 110472 | Corn-Soy Blend | 750 |  |  | 110170 | Emergncy Fd | 500
 |  | 5 | 110170 | Emergncy Fd | 500 |  | 5 | 100566 | Oil | 1200 |  |  | 110472 | Corn-Soy Blend | 750
 |  | 5 | 110472 | Corn-Soy Blend | 750
 |  | 5 | 100566 | Oil | 1000
 |  | 5 | 100566 | Oil | 200
Spreadsheet: 687027d1594917948-get-unique-list-of-occurances-and-total-value-counts-from-a-two-column-list-pubjay2
Sheet: Sheet1

Apple | 3 |  |  | Apples | 18
Orange | 5 |  |  | Orange | 29
Grape | 1 |  |  | Grape | 20
Pear | 9 |  |  | Pear | 19
Apple | 8 |  |  | Carrot | 0
Orange | 2
Grape | 12
Pear | 2
Apple | 7
Orange | 22
Grape | 7
Pear | 8
Carrot | 0
Spreadsheet: c13f2691-4b78-49ce-952c-775d4c6d9008
Sheet: Sheet1

[NAME] | 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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
 | Player and Team Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 1 | Game 2 | Game 3 | Game 4 | Game 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 22 | 18 | 25 | 25 | 8
Date: | 2008-09-18 00:00:00 |  |  |  |  |  |  | mailto:[EMAIL] |  |  |  |  |  |  |  | @ [NAME] |  |  |  |  | 25 | 25 | 18 | 16 | 15
 |  | Gm | Serving |  |  |  |  | Attacking |  |  |  |  | Set |  | Blocks |  |  |  |  | Receptions
# | Player Name | P | Att. | Aces | [NAME]. | % | Ace/G | TA | Kills | [NAME]. | % | Kill/G | Asst. | Ast/G | Solo | Asst. | Blk/G | [NAME] | Dig/G | total attmps | on target | off target | play     able | errors | ratio
 | [NAME]
2 | Kelsey Swalling | 5 | 12 | 1 | 2 | 0.8333333333333334 | 0.2 | 5 | 4 | 1 | 0.6 | 0.8 | 18 | 3.6 | 2 | 2 | 0.8 | 4 | 0.8 | 3 | 1 |  | 2 |  | 1.666666666666667
3 | Kelsey Clairmont | 5 |  |  |  |  | 0 |  |  |  |  | 0 | 5 | 1 |  |  | 0 | 7 | 1.4 | 2 | 1 |  | 1 |  | 2
4 | [NAME] | 5 | 11 | 3 | 1 | 0.9090909090909091 | 0.6 |  |  |  |  | 0 |  | 0 |  |  | 0 | 6 | 1.2 | 17 | 7 | 2 | 7 | 1 | 1.882352941176471
5 | [NAME] | 5 | 14 | 2 | 5 | 0.6428571428571429 | 0.4 | 20 | 9 | 7 | 0.1 | 1.8 |  | 0 | 1 |  | 0.2 | 14 | 2.8 | 21 | 8 | 3 | 7 | 3 | 1.761904761904762
6 | [NAME] | 5 | 12 | 0 | 3 | 0.75 | 0 | 24 | 9 | 4 | 0.2083333333333333 | 1.8 |  | 0 |  |  | 0 | 18 | 3.6 | 33 | 16 | 2 | 13 | 2 | 1.96969696969697
7 | [NAME] | 5 |  |  |  |  | 0 | 4 | 2 | 2 | 0 | 0.4 |  | 0 |  | 1 | 0.2 |  | 0 | 0
8 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 | [NAME] | 5 |  |  |  |  | 0 | 9 | 5 | 4 | 0.1111111111111111 | 1 |  | 0 | 2 | 2 | 0.8 |  | 0 | 0 |  | 0
10 | [NAME] | 5 | 7 | 2 | 0 | 1 | 0.4 | 13 | 5 | 3 | 0.1538461538461539 | 1 |  | 0 | 1 | 1 | 0.4 | 3 | 0.6 | 14 | 5 | 2 | 5 | 2 | 1.714285714285714
11 | [NAME] | 5 | 13 | 2 | 2 | 0.8461538461538461 | 0.4 |  |  |  |  | 0 |  | 0 |  |  | 0 | 1 | 0.2 | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Team Totals | 5 | 69 | 10 | 13 | 0.8115942028985508 | 2 | 75 | 34 | 21 | 0.1733333333333333 | 6.8 | 23 | 4.6 | 6 | 3 | 1.8 | 53 | 10.6 | 90 | 38 | 9 | 35 | 8 | 1.855555555555556
Spreadsheet: 879307d1726781214-dept-and-date-to-auto-calculate-based-on-todays-date-book1
Sheet: Sheet1

Date | Shift | Dept
2024-02-09 00:00:00 | 1 | Grocery
2024-02-11 00:00:00
2024-02-23 00:00:00 | 2 | Produce
2024-03-03 00:00:00 | 2 | Deli
2024-03-08 00:00:00 | 2 | Produce
2024-03-15 00:00:00 | 2 | Produce
2024-03-19 00:00:00
2024-03-29 00:00:00
2024-03-30 00:00:00
2024-04-02 00:00:00
2024-04-13 00:00:00
2024-04-17 00:00:00
2024-04-22 00:00:00
2024-04-22 00:00:00
2024-04-29 00:00:00 | 1 | Deli
2024-06-10 00:00:00 | 1 | Produce
2024-07-29 00:00:00 | 3 | Freezer
2024-07-29 00:00:00 | 1 | Freezer
2024-08-04 00:00:00 | 2 | Produce
2024-08-16 00:00:00 | 2 | Deli
2024-08-16 00:00:00 | 1 | Grocery
2024-08-19 00:00:00 | 3 | Deli
2024-08-31 00:00:00 | 2 | Meat
2024-06-13 00:00:00 | 1 | Freezer
2024-07-09 00:00:00 | 1 | Deli
2024-08-16 00:00:00 | 3 | Deli
2024-07-24 00:00:00 | 1 | Grocery
2024-07-28 00:00:00
2024-08-09 00:00:00 |  | Produce
2024-07-15 00:00:00 | 2 | Produce
2024-08-14 00:00:00 | 2 | Meat
Denied
Spreadsheet: 53741d1253654593-general-ledger-template-general-ledger-wilverley
Sheet: Monthly Expenses Summary

2009 Monthly Expenses
G/L Code | Account Title | Jan | Feb | Mar | April | May | June | July | Aug | Sept | Oct | Nov | Dec | 2009
10 | [NAME]
11 | Freehold Property Depriciation
20 | Furniture & Equipment
21 | Furniture & Equipment Depriciation
1001 | Stock
1100 | Debtors Control Account
1103 | Prepayments
1200 | Bank Current Account
1210 | Bank Deposit Account
1230 | Petty Cash
2100 | Creditors Control Account
4004 | [NAME]
4005 | Guest Accommodation
4010 | Garage Rent
4015 | Newspapers
4020 | Laundry
4025 | Meals
4030 | TV Licence
4035 | Medical Supplies
4036 | Room Redecoration
4037 | Telephone Receipts
4039 | Donations
5009 | Discounts Taken
6102 | Provisions
6105 | Management Fee
6110 | Cleaning and Laundry
6111 | Waste Disposal
6120 | Medical Expenses
6121 | Scabies Prescriptions
6151 | ABM
6155 | Staff Training
7147 | Council Tax
7150 | Sewerage and Water
7155 | Insurance
7160 | Electricity
7161 | Gas
7162 | Utilities Monitoring
7165 | Telephone
7170 | Postage, Stationery & Advertising
7172 | Computer Expenses (IT)
7175 | Travelling Expenses
7180 | Accountancy
7185 | Audit Fees
7187 | Legal & Professional Fees
7190 | Sundry Expenses
7191 | CRB Checks
7193 | Newspapers
7195 | Keep Fit
7200 | Garden Expenses
7205 | Repairs & Renewals: Linen & Soft Furnishings
7210 | Repairs & Renewals: Plant & Equipment
7215 | Repairs & Renewals: Kitchenware Crockery & Cutlery
7220 | Repairs & Renewals: Property
7221 | Repairs & Renewals: Property Redecoration Reserve
7225 | Repairs & Renewals: General
7226 | Overalls & Uniforms
7227 | Hire of Equipment
7235 | Profit on Sale of Asset
7237 | Depreciation Buildings
7240 | Depreciation Furniture & Equipment
7252 | Registration Fees
7254 | Cashed Cheques Account
 | Total
Spreadsheet: 217651d1362141855-rollup-data-from-multiple-excel-sheets-kpi-worksheet_test
Sheet: Q4 Analysis

 |  | Performance Indicators
 |  | Quarterly Q4
Department | Exceeds Target | On Target | Slightly less than Target | Less than Target | Total KPIs
 | 1 | 2 | 1 | -1
D5
D2
D1
D3
D4
D6
D8
D7
D9
D10
Overall Performance
 |  |  |  |  | 1
Number of departments measured |  |  |  | 6
Number of target departments to measure |  |  |  | 6
% of departments measured
Spreadsheet: 174442d1345057246-scoreboard-wins-1-up-updated-test-course
Sheet: Lookups

 | Holes To Play
 |  | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0
up By | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS | AS
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Up
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Up
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 107730d1304882672-many-multiple-regressions-residuals-residuals-variance
Sheet: Regr Output

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.9878032946832511
R Square | 0.9757553489870858
Adjusted R Square | 0.9606024421040145
Standard Error | 0.01385921384668591
Observations | 14
ANOVA
 | df | SS | MS | F | [NAME]
Regression | 5 | 0.06184323260918445 | 0.01236864652183689 | 64.3939381741457 | 3.027464728043163e-06
Residual | 8 | 0.001536622467585364 | 0.0001920778084481705
Total | 13 | 0.06337985507676981
 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Intercept | 0.01260016800226637 | 0.00533043087765965 | 2.363817914809643 | 0.04568514589538093 | 0.0003081723661179734 | 0.02489216363841476 | 0.0003081723661179734 | 0.02489216363841476
X Variable 1 | 1.095678113124583 | 0.1569976536125522 | 6.97894578621258 | 0.0001150333905781877 | 0.7336408749757748 | 1.457715351273392 | 0.7336408749757748 | 1.457715351273392
X Variable 2 | 0.8787099475993184 | 0.237146757625058 | 3.7053424486984 | 0.005996358672752035 | 0.3318485443174506 | 1.425571350881186 | 0.3318485443174506 | 1.425571350881186
X Variable 3 | -0.1788628924642957 | 0.3120791757502644 | -0.5731330584115212 | 0.5823018080650033 | -0.898518761660987 | 0.5407929767323957 | -0.898518761660987 | 0.5407929767323957
X Variable 4 | 0.132135295370401 | 0.1708569976875567 | 0.7733677704675264 | 0.4615427622260171 | -0.2618616475001824 | 0.5261322382409845 | -0.2618616475001824 | 0.5261322382409845
X Variable 5 | -0.4286307985307354 | 0.466450006832381 | -0.9189211968106241 | 0.3850054233372748 | -1.504266442263607 | 0.6470048452021366 | -1.504266442263607 | 0.6470048452021366
RESIDUAL OUTPUT |  |  |  | PROBABILITY OUTPUT
Observation | Predicted Y | Residuals |  | Percentile | Y
1 | 0.0007455363660632732 | -0.005928769582598315 |  | 3.571428571428572 | -0.1414201295536606
2 | -0.008745276642223911 | -0.0106553776481248 |  | 10.71428571428572 | -0.1072322205070415
3 | 0.05417044067202313 | 0.002481375313126546 |  | 17.85714285714286 | -0.03303043509394809
4 | 0.01444089655023326 | 0.0205552421320656 |  | 25 | -0.0311557594545284
5 | 0.06022571537197542 | 0.01182104695157775 |  | 32.14285714285715 | -0.01940065429034871
6 | 0.05398693685855943 | -0.0119445721708273 |  | 39.28571428571428 | -0.005183233216535042
7 | 0.01567859086870074 | 0.00531044247841635 |  | 46.42857142857143 | 0.01278311952249372
8 | -0.1224121072396322 | -0.01900802231402839 |  | 53.57142857142857 | 0.02098903334711709
9 | -0.1206793200427349 | 0.01344709953569345 |  | 60.71428571428572 | 0.03499613868229886
10 | 0.05253996733571606 | -0.003627854072858705 |  | 67.85714285714286 | 0.04204236468773213
11 | -0.03558994799401038 | 0.002559512900062288 |  | 75 | 0.04891211326285735
12 | 0.009049953518410214 | 0.003733166004083506 |  | 82.14285714285714 | 0.05665181598514968
13 | -0.03094633854353006 | -0.0002094209109983342 |  | 89.28571428571429 | 0.07204676232355317
14 | 0.1327590854683477 | -0.008533868615589732 |  | 96.42857142857143 | 0.124225216852758
Spreadsheet: 836015d1689051773-finding-the-price-from-newest-date-to-oldest-with-n-data-example
Sheet: Sheet1

SKU | Price | PO date |  |  | Result: |  | Price 1 | Price 2 | Price 3
A | 34.242424 | 2015-12-18 00:00:00 |  |  |  | A | 38.06666666666667 | 34.242424 | 37.86666666666667
A | 38.06666666666667 | 2017-07-18 00:00:00 |  |  |  | B | 38.84848486666667 | 39.51515153333334
A | 37.86666666666667 | 2015-09-30 00:00:00 |  |  |  | C | 34.84848466666667 | 34.84848484666666 | 35
A | 38.53333333333333 | 2015-04-14 00:00:00 |  |  |  | D | 35.75757575333333
A | 39.86666666666667 | 2015-01-15 00:00:00 |  |  |  | E | 37.87878787333334 | 37.87878854 | 38
B | 39.51515153333334 | 2016-03-31 00:00:00
B | 38.84848486666667 | 2016-04-16 00:00:00 |  |  | [NAME]:
C | 34.84848466666667 | 2016-02-11 00:00:00 |  |  |  |  | Price 1 | Price 2 | Price 3
C | 34.84848484666666 | 2016-01-20 00:00:00 |  |  |  | A
C | 35 | 2015-12-16 00:00:00 |  |  |  | B
D | 35.75757575333333 | 2015-11-14 00:00:00 |  |  |  | C
E | 38 | 2015-02-24 00:00:00 |  |  |  | D
E | 38 | 2015-04-07 00:00:00 |  |  |  | E
E | 38 | 2015-06-17 00:00:00
E | 38 | 2015-07-09 00:00:00
E | 38 | 2015-08-25 00:00:00 |  |  | Price 1 | Price with newest date
E | 37.87878854 | 2015-09-17 00:00:00 |  |  | Price 2 | Price with 2nd newest date
E | 37.87878787333334 | 2015-10-17 00:00:00 |  |  | Price 3 | Price with 3rd newest date
Spreadsheet: 841516d1693696593-using-sumproduct-to-return-values-based-on-criteria-when-date-filter-changes-excel-formula-09-01-2023-bvj-
Sheet: Summary

Segment | # of Cases/Phases | Avg Days to Completion
B Cases
MM Cases
D Phases
M Phases
S Cases
Total
Team Member | B Cases | MM Cases
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
WholWorth
Total
Spreadsheet: 328166d1403800344-vlookup-with-rows-with-identical-numbers-formula-help-for-yes
Sheet: Sheet1

0 | Loc # | MP # | MP Name | [NAME] | MP with multiple Instrument numbers? | Device # |  | Status | District: North or South | Tech | Inspect semi-annually
1 | 2 | 00002MP01 |  |  |  |  |  |  | North
 | 2 | 00002MP01 |  |  |  |  |  |  | North
2 | 4 | 00004MP02 |  |  |  |  |  |  | North
 | 4 | 00004MP02 |  |  |  |  |  |  | North
3 | 5 | 00005MP01 |  |  |  |  |  |  | North
 | 5 | 00005MP01 |  |  |  |  |  |  | North
4 | 5 | 00005MP02 |  |  |  |  |  |  | North
 | 5 | 00005MP02 |  |  |  |  |  |  | North
5 | 6 | 00006MP01 |  |  |  |  |  |  | North
 | 6 | 00006MP01 |  |  |  |  |  |  | North
6 | 9 | 00009MP01 |  |  |  |  |  |  | North
 | 9 | 00009MP01 |  |  |  |  |  |  | North
7 | 31 | 00031MP01 |  |  |  |  |  |  | North
 | 31 | 00031MP01 |  |  |  |  |  |  | North
8 | 33 | 00033MP01 |  |  |  |  |  |  | North
 | 33 | 00033MP01 |  |  |  |  |  |  | North
9 | 35 | 00035MP01 |  |  |  |  |  |  | North
 | 35 | 00035MP01 |  |  |  |  |  |  | North
10 | 43 | 00043MP02 |  |  |  |  |  |  | North
 | 43 | 00043MP02 |  |  |  |  |  |  | North
11 | 44 | 00044MP01 |  |  |  |  |  |  | North
 | 44 | 00044MP01 |  |  |  |  |  |  | North
12 | 44 | 00044MP02 |  |  |  |  |  |  | North
13 | 51 | 00051MP01 |  |  |  |  |  |  | North
 | 51 | 00051MP01 |  |  |  |  |  |  | North
14 | 70 | 00070MP01 |  |  |  |  |  |  | North |  | Yes
 | 70 | 00070MP01 |  |  |  |  |  |  | North
15 | 81 | 00081MP01 |  |  |  |  |  |  | North |  | Yes
 | 81 | 00081MP01 |  |  |  |  |  |  | North
16 | 114 | 00114MP01 |  |  |  |  |  |  | North
 | 114 | 00114MP01 |  |  |  |  |  |  | North
17 | 123 | 00123MP01 |  |  |  |  |  |  | North |  | Yes
 | 123 | 00123MP01 |  |  |  |  |  |  | North
18 | 125 | 00125MP01 |  |  |  |  |  |  | North |  | Yes
 | 125 | 00125MP01 |  |  |  |  |  |  | North
19 | 125 | 00125MP02 |  |  |  |  |  |  | North
20 | 126 | 00126MP01 |  |  |  |  |  |  | North |  | Yes
 | 126 | 00126MP01 |  |  |  |  |  |  | North
Spreadsheet: 26682d1219058773-regarding-index-and-match-function-problem-index-match-1-
Sheet: Sheet2

Date | Ref No | Profile
2008-08-15 00:00:00 | 100 | 20
2008-08-15 00:00:00 | 101 | 34
2008-08-15 00:00:00 | 102 | 64
2008-08-16 00:00:00 | 100 | 58
2008-08-16 00:00:00 | 101 | 94
2008-08-16 00:00:00 | 102 | 84
Spreadsheet: cc9d008f-515e-47b6-ab0d-f7efaa1ddae1
Sheet: Sheet1

Unnamed: 0 | GOVERNOR | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2000-11-07 00:00:00
Summary By | Humphrey, r | Shaheen, d | Brown, ind | [NAME], [NAME] | [NAME]
Counties
Belknap | 12980 | 11994 | 1664 | 208
Carroll | 11691 | 10363 | 1260 | 288
Cheshire | 12554 | 17734 | 2245 | 478
Coos | 6470 | 7011 | 896 | 156
[NAME] | 17030 | 18425 | 2066 | 609
Hillsborough | 75067 | 78522 | 9523 | 1763
Merrimack | 24479 | 33571 | 4766 | 677
Rockingham | 60837 | 61247 | 8743 | 1395
[NAME] | 17234 | 28044 | 3326 | 620
[NAME] | 8610 | 8127 | 1415 | 252
TOTALS | 246952 | 275038 | 35904 | 6446
[NAME]libertarian
ind=independent