tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678218d1589787021-lookup-a-value-and-return-column-that-has-non-blank-value-trucksummary1
Sheet: Truckplan

 |  | DATA |  |  |  |  |  |  |  | RESULTS
 |  | Date | Truck1 |  |  |  |  |  |  |  | Truck1
 |  |  | Zone A | Zone B | Zone C | Zone D | Zone E |  |  | Date | Zone | Planned Nr of Trips
 |  |  | Nr of trips
 |  | Min Trips | 3 | 3 | 2 | 2 | 0
 |  | 2020-04-06 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-06 00:00:00 | Zone A | 4
 |  | 2020-04-07 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-07 00:00:00 | Zone A | 4
 |  | 2020-04-08 00:00:00 |  | 3 | 1 |  |  |  |  | 2020-04-08 00:00:00 | Zone B, Zone C | 3,1
 |  | 2020-04-09 00:00:00 |  | 4 |  |  |  |  |  | 2020-04-09 00:00:00 | Zone B | 4
 |  | 2020-04-10 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-10 00:00:00 | Zone C | 3
 |  | 2020-04-11 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-11 00:00:00 | Zone C | 3
 |  | 2020-04-12 00:00:00 |  |  | 0 |  |  |  |  | 2020-04-12 00:00:00 | Maitenance | 0
 |  | 2020-04-13 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-13 00:00:00 | Zone C | 3
 |  | 2020-04-14 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-14 00:00:00 | Zone C | 3
 |  | 2020-04-15 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-15 00:00:00 | Zone C | 3
 |  | 2020-04-16 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-16 00:00:00 | Zone D | 2
 |  | 2020-04-17 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-17 00:00:00 | Zone D | 2
 |  | 2020-04-18 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-18 00:00:00 | Zone A | 4
 |  | 2020-04-19 00:00:00 | 0 |  |  |  |  |  |  | 2020-04-19 00:00:00 | Maitenance | 0
Spreadsheet: 693215d1598868020-if-formula-but-ignore-blank-and-move-to-next-criteria-pq-mf-summary-aligw
Sheet: Males

 | Names | Dates | Location |  | Names | Dates | Location
 |  |  |  |  | [NAME] | 1982-09-01 00:00:00 | London
 |  |  |  |  | [NAME] | 1988-01-01 00:00:00 | Edinburgh
Spreadsheet: 65820d1266477630-lookup-formula-demo
Sheet: Kai

Name | Birthday |  |  | Address | phone | Start date
 |  |  |  | Job | Cell | Quit Date
MrV | 1976 | Jan | 12 | Don't know street | 55223222 | 2007-03-02 00:00:00
 |  |  |  | Secretary | 905555221
MrU | 1978 | Mar | 23 | Have not a clue Rd | 22555 | 2008-04-06 00:00:00
 |  |  |  | Manager | 905555221
MrQ | 1979 | Apr | 24 | Wouldn't know how to to get there Street | 552222552 | 2010-01-02 00:00:00
 |  |  |  | sales clerk | 905555221
Spreadsheet: harry_arora__12154__Plan_IncomeSheets_Presto
Sheet: Midwest Power Trading

Income Statement - ($000s)
 |  |  | 2001 Forecast |  | 2002 Plan |  | [NAME]
Originations |  | $ | 0 | $ | 0 | $
Trading |  |  | 0 |  | 0
FV-Investments |  |  | 0 |  | 0
Accrual |  |  | 0 |  | 0
Operating Expenses |  |  | 0 |  | 0
Other |  |  | 0 |  | 0
Total Margin |  | $ |  | $ |  | $
Capital Charge |  |  | 0 |  | 0
Total Margin Net of Capital Charge |  | $ |  | $ |  | $
Compensation/Taxes and Benefits |  |  |  |  |  |  |  |  |  |  | 1000
Employee Expense
Travel/Entertainment |  |  |  |  |  |  |  |  |  |  | -1
Consulting |  |  | 3
Office
Controllable Infrastructure
System Development |  |  | 0 |  | 0
Insurance |  |  | 0 |  | 0
Analyst Associates (includes Comp, Taxes & Benefits and Allocation) |  |  | 432
Other Expense
Outside Legal |  |  | 2.256 |  | 0
Outside Tax |  |  | 0 |  | 0
Depreciation & Amortization |  |  | 4.506 |  | 0
Total Direct Expenses |  | $ |  | $ |  | $
Other Allocated Expenses |  | $ |  | $ |  | $
Pre-Tax Income |  | $ |  | $ |  | $
Headcount
Executive |  |  | 1 |  | 1
Director |  |  | 0 |  | 0
Manager |  |  | 3 |  | 4
Analyst and Associates |  |  | 2 |  | 5
Support Departments |  |  | 4 |  | 5
Total Headcount
2002 Plan (in thousands) |  |  | Team |  | ENA Total
Direct Expense Headcount Ratio |  | $ |  | $
Productivity [NAME] |  | $ |  | $
ROCE
Spreadsheet: 749144d1632528448-filter-cells-by-number-of-spaces-at-start-filter-cells-by-number-of-spaces-at-start
Sheet: Sheet1

Text |  | 3 | <- change this variable
0 leading space |  |  | <- added "x" at the end to avoid counting trailing spaces
1 leading space
2 leading space
3 leading space
4 leading space
5 leading space
6 leading space
0 leading space
1 leading space
2 leading space |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1360005-filter-cells-by-number-of-spaces-at-start.html
3 leading space
4 leading space
5 leading space
6 leading space
0 leading space
1 leading space
2 leading space
3 leading space
4 leading space
5 leading space
6 leading space
Spreadsheet: 30047d1225330807-contains-symbol-test
Sheet: Sheet1

 |  |  | January, April, July & October
PO2016202 | 24 | 16x20x2 | MAU #3, 4, 90, and 91 |  |  |  |  | 1, 14, 27, 40
PO2020242 | 120 | 20x24x2 |  |  |  |  |  | 1, 14, 27, 40
 |  |  | February, May, August, & November
PO2016202 | 18 | 16x20x2 | MAU #1, 8, and 11 |  |  |  |  | 6, 18, 32, 45
PO2020242 | 90 | 20x24x2 |  |  |  |  |  | 6, 18, 32, 45
SERVICE | 4 | Auto Roll | FU1 Advance Auto Roll |  |  |  |  | 6, 18, 32, 45
SERVICE | 4 | Install | Install New Mini-Auto Roll in November |  |  |  |  | 45
 |  |  | March, June, September, & December
PO2016202 | 24 | 16x20x2 | MAU # 6, 7, 9, and 10 |  |  |  |  | 10, 23, 36, 49
PO2020242 | 120 | 20x24x2 |  |  |  |  |  | 10, 23, 36, 49
SERVICE | 4 | Auto Roll | FU2 Advance Auto Roll |  |  |  |  | 10, 23, 36, 49
SERVICE | 4 | Install | Install New Mini-Auto Roll in March |  |  |  |  | 3
Spreadsheet: 06ddab14-2977-4fbf-a7b4-9b4eb9fb5fe1
Sheet: Sheet1

Unnamed: 0 | The German Squat Program | 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
 |  |  |  |  |  |  |  |  |  |  | Reps: | Ascending 5 to 10 |  | 45
 |  |  |  |  | Current Max | 100 |  |  |  |  |  | Ascending 6 to 11 |  | 51
 |  |  |  |  |  |  |  |  |  |  |  | Ascending 7 to 12 |  | 57
Week One |  | Day One |  |  | Day Two |  |  | Day Three |  |  |  | 5 × 15 |  | 75
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 70 | 5, 6, 7, 8, 9, 10 |  | 50 | 5 × 15 |  | 70 | 6, 7, 8, 9, 10, 11 |  | Tonnage | 10470 | Working Reps | 171
Week Two |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 75 | 5, 6, 7, 8, 9, 10 |  | 60 | 5 × 15 |  | 77.5 | 5, 6, 7, 8, 9, 10 |  | Tonnage | 11362.5 | Working Reps | 165
Week Three |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 75 | 7, 8, 9, 10, 11, 12 |  | 65 | 5 × 15 |  | 77.5 | 7, 8, 9, 10, 11, 12 |  | Tonnage | 13567.5 | Working Reps | 189
Week Four |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 80 | 5, 6, 7, 8, 9, 10 |  | 70 | 5 × 15 |  | 82.5 | 5, 6, 7, 8, 9, 10 |  | Tonnage | 12562.5 | Working Reps | 165
Week Five |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 80 | 7, 8, 9, 10, 11, 12 |  | 70 | 5 × 15 |  | 82.5 | 7, 8, 9, 10, 11, 12 |  | Tonnage | 14512.5 | Working Reps | 189
Week Six |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 85 | 5, 6, 7, 8, 9, 10 |  | 72.5 | 5 × 15 |  | 87.5 | 5, 6, 7, 8, 9, 10 |  | Tonnage | 13200 | Working Reps | 165
Week Seven |  | Day One |  |  | Day Two |  |  | Day Three
 |  | Weight | Sets & Reps |  | Weight | Sets & Reps |  | Weight | Sets & Reps
 |  | 85 | 7, 8, 9, 10, 11, 12 |  | 75 | 5 × 15 |  | 87.5 | 7, 8, 9, 10, 11, 12 |  | Tonnage | 15457.5 | Working Reps | 189
 |  |  |  |  |  |  |  |  |  |  | TOTALS
 |  | [NAME] between reps are different sets, e.g. week one day one is 6 sets, first set is 5 reps last set is 10 reps |  |  |  |  |  |  |  |  | Tonnage | 91132.5 | Working Reps | 1233
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 105467 |  |  | 77908 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 131083 |  |  | 45263 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 134074 | 161714 |  | 31644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 147980 | 162355 |  | 16460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 145971 | 164906 |  | 22551 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 127718 |  |  | 45207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 172839 |  |  | 8766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 168553 |  |  | 21417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 147907 |  |  | 28501 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2000-11-30 00:00:00 |  |  |  | -75432
 | 2000-12-09 00:00:00
Spreadsheet: 870680d1717149874-summarise-multiple-tables-into-master-table-summary-formula-request
Sheet: StockA

 | Date | Stamp | FX | Comm |  | Year | Stamp | FX | Comm
 | 2020-01-27 00:00:00 | 5 |  | 4.95 |  | 2008
 | 2021-02-26 00:00:00 |  |  |  |  | 2009
 | 2021-02-26 00:00:00 |  |  |  |  | 2010
 | 2021-05-28 00:00:00 |  |  |  |  | 2011
 | 2021-08-31 00:00:00 |  | 34 |  |  | 2012
 | 2021-08-31 00:00:00 |  |  |  |  | 2013
 | 2021-09-10 00:00:00 | 5 |  | 9.95 |  | 2014
 | 2021-11-19 00:00:00 |  |  |  |  | 2015
 | 2021-11-19 00:00:00 |  |  |  |  | 2016
 | 2021-12-31 00:00:00 |  |  |  |  | 2017
 | 2022-01-24 00:00:00 | 10 |  | 4.95 |  | 2018
 | 2022-02-28 00:00:00 |  |  |  |  | 2019
 | 2022-05-04 00:00:00 | 9.99 |  | 9.95 |  | 2020
 | 2022-05-20 00:00:00 | 9.99 |  | 9.95 |  | 2021
 | 2022-05-31 00:00:00 |  |  |  |  | 2022
 | 2022-08-31 00:00:00 |  | 67 |  |  | 2023
 | 2022-08-31 00:00:00 |  |  |  |  | 2024
 | 2022-09-30 00:00:00 | 50 |  | 9.95 |  | 2025
 | 2022-11-28 00:00:00 |  |  |  |  | 2026
 | 2022-11-28 00:00:00 |  |  |  |  | 2027
 | 2022-11-30 00:00:00 | 1.79 |  | 1.5 |  | 2028
 | 2022-12-31 00:00:00 |  |  |  |  | 2029
 | 2023-02-20 00:00:00 |  |  |  |  | 2030
 | 2023-02-20 00:00:00 |  |  |  |  | 2031
 | 2023-02-22 00:00:00 | 1.84 |  | 1.5 |  | 2032
 | 2023-06-07 00:00:00 |  |  |  |  | 2033
 | 2023-06-07 00:00:00 |  |  |  |  | 2034
 | 2023-06-09 00:00:00 | 1.87 |  | 1.5 |  | 2035
 | 2023-08-31 00:00:00 |  |  |  |  | 2036
 | 2023-09-04 00:00:00 | 1.91 |  | 1.5 |  | 2037
 | 2023-12-01 00:00:00 |  |  |  |  | 2038
 | 2023-12-01 00:00:00 |  |  |  |  | 2039
 | 2023-12-05 00:00:00 | 1.95 |  | 1.5 |  | 2040
 | 2023-12-31 00:00:00 |  |  |  |  | 2041
 | 2024-03-01 00:00:00 |  |  |  |  | 2042
 | 2024-03-05 00:00:00 | 1.99 |  | 1.5 |  | 2043
 | 2024-05-07 00:00:00 |  |  | 5 |  | 2044
Spreadsheet: 678720d1590034980-table-imported-from-a-web-page-manipulated-and-now-i-would-like-to-organize-the-columns-excel-forum-fig-2
Sheet: Sheet1

Name | Address | Bicycle Hire on Site | Bicycle Hire Nearby | Bar on Site | Bar Nearby | Seaside Beach Nearby | Seaside Beach Onsite | Lake/River Beach Onsite | Lake/River Beach Nearby | Fishing Onsite | Fishing Nearby | [NAME] | Golf Nearby | [NAME] | Childrens Play Area | Pets Allowed | [NAME] | Riding Onsite | Riding Nearby | Sailing Onsite | Sailing Nearby | Small Site | Glamping | Spa/Wellbeing | Restaurant | Shop Onsite | Shop Nearby | Takeaway Food | [NAME] | Wifi Free | wifi Chargeable | [NAME] (all site) | Wifi Partial Site
Camping Ar Kleguer | France, Brittany, Finistère,  [NAME] | Bicycle Hire on Site | Bar Nearby | Bar on Site | Seaside Beach Onsite | Fishing on Site | Golf Nearby | Childrens Play Area | Riding Nearby | Sailing Nearby | Pool on Site | Pets allowed | Shop Nearby | Shop on Site | Takeaway Food | Wifi Free | Wifi Partial Site
Name | Address | Bicycle Hire on Site | Bicycle Hire Nearby | Bar on Site | Bar Nearby | Seaside Beach Nearby | Seaside Beach Onsite | Lake/River Beach Onsite | Lake/River Beach Nearby | Fishing Onsite | Fishing Nearby | [NAME] | Golf Nearby | [NAME] | Childrens Play Area | Pets Allowed | [NAME] | Riding Onsite | Riding Nearby | Sailing Onsite | Sailing Nearby | Small Site | Glamping | Spa/Wellbeing | Restaurant | Shop Onsite | Shop Nearby | Takeaway Food | [NAME] | Wifi Free | wifi Chargeable | [NAME] (all site) | Wifi Partial Site
 |  |  |  | Bar on Site | Bar Nearby |  |  |  |  | Fishing on Site |  |  | Golf Nearby |  | Childrens Play Area | Pets allowed | Pool on Site |  | Riding Nearby |  | Sailing Nearby |  |  |  |  | Shop on Site | Shop Nearby | Takeaway Food |  | Wifi Free |  |  | Wifi Partial Site
Spreadsheet: 757332d1638195363-why-v-lookup-is-not-showing-the-result-natraj-yarn-stock-fresh
Sheet: YARN IN

DATE | [NAME]. | PARTY NAME | YARN CODE | YARN TYPE | SKU | SHADE | COLOR | NO. OF UNITS | UNIT | P.O. NO.
2021-11-01 00:00:00 | 392 | FINE IMPEX |  |  |  |  |  | 1250 | KGS
2021-11-02 00:00:00 |  | KATYAL TRADING CO |  |  |  |  |  | 291.81 | KGS
2021-11-02 00:00:00 |  | KATYAL TRADING CO |  |  |  |  |  | 226.57 | KGS
2021-11-02 00:00:00 | 1424 | AN YARN |  |  |  |  |  | 993.6 | KGS
2021-11-02 00:00:00 | 1424 | AN YARN |  |  |  |  |  | 2911.5 | KGS
2021-11-06 00:00:00 |  | SWASTIK SALES CORP |  |  |  |  |  | 818.56 | KGS
2021-11-06 00:00:00 | 1424 | RAYMONS YARN |  |  |  |  |  | 64.03 | KGS
2021-11-06 00:00:00 | 11 | SWASTIK SALES CORP |  |  |  |  |  | 818.56 | KGS
2021-11-10 00:00:00 | 1465 | AN YARN |  |  |  |  |  | 3864 | KGS
2021-11-10 00:00:00 | 1619 | AYUSH INTERNATIONAL |  |  |  |  |  | 1814.4 | KGS
2021-11-11 00:00:00 | 1306 | KATYAL TRADING CO |  |  |  |  |  | 543.36 | KGS
2021-11-11 00:00:00 | 1306 | KATYAL TRADING CO |  |  |  |  |  | 319.78 | KGS
2021-11-11 00:00:00 | 1306 | KATYAL TRADING CO |  |  |  |  |  | 215.87 | KGS
2021-11-11 00:00:00 | 1309 | KATYAL TRADING CO |  |  |  |  |  | 312.98 | KGS
2021-11-11 00:00:00 | 1309 | KATYAL TRADING CO |  |  |  |  |  | 224.05 | KGS
2021-11-11 00:00:00 | 1309 | KATYAL TRADING CO |  |  |  |  |  | 316.85 | KGS
2021-11-12 00:00:00 | 3022 | RAYMONS YARN |  |  |  |  |  | 324.08 | KGS
2021-11-13 00:00:00 |  | PLATINUM YARN | WE104 |  |  |  |  | 1633.8 | KGS | 4581 A/4582 A
2021-11-15 00:00:00 |  | FINE IMPEX | WE247 |  |  |  |  | 1250 | KGS | 4592
2021-11-15 00:00:00 |  | FINE IMPEX | WE247 |  |  |  |  | 1250 | KGS | 4592
2021-11-16 00:00:00 |  | FINE IMPEX | WE247 |  |  |  |  | 1350 | KGS | 4592
2021-11-18 00:00:00 |  | AYUSH INTERNATIONAL | WA114 |  |  |  |  | 1890 | KGS
Spreadsheet: kim_ward__20827__Prepay Quantity Summary
Sheet: Quantity by Point

Year | Pasadena | SMUD | SMUD | Glendale | Glendale | [NAME] | NGPA | Total
 | Topock | Malin | Permian | Topock | AECO | Sumas | NNG
 | MMBtu | MMBtu | MMBtu | MMBtu |  | MMBtu | MMBtu
1999 |  |  |  |  | 0
2000
2001 |  |  |  | 0
2002 |  |  |  | 0
2003 |  |  |  | 0
2004 |  |  |  | 0
2005 |  |  |  | 0
2006 |  |  |  | 0
2007 |  |  |  | 0
2008 |  |  |  | 0
2009 |  |  |  | 0
2010 |  |  |  | 0
2011 |  |  |  | 0
TOTAL:
Spreadsheet: 0d9c75cf-ee7e-4514-bf9d-61afb4d69f9e
Sheet: Sheet1

Service Type | Revenue Code | Unnamed: 2 | Rate | Unit Value
 | Acute Home Health | Long Term Home Health
RN Assess and Teach | 589 | - | 93.38 | Acute only- one visit up to 2 ½ hours
RN/LPN | 550 | 551 | 93.38 | One visit up to 2 ½ hours
RN Brief 1st of Day | - | 590 | 65.36 | One Visit
RN Brief 2nd or > | - | 599 | 45.75 | One Visit
HHA BASIC | 570 | 571 | 33.21 | One hour
[NAME] | 572 | 579 | 9.93 | For visits lasting more than one hour,  extended units of 15-30 minutes
PT | 420 | 421 (for 0-17 years LTHH) | 102.12 | One Visit up to 2 ½ hours
PT for HCBS Home Mod Evaluation | 424 | 424 | 102.12 | 1-2 visits
OT | 430 | 431 (for 0-17 years LTHH) | 102.78 | One visit up to 2 ½ hours
OT for HCBS Home Mod Evaluation | 434 | 434 | 102.78 | 1-2 visits
S/LT | 440 | 441 (for 0-17 years LTHH) | 110.97 | One visit up to 2 ½ hours
Telehealth Service | 583 (with 98969) | 780 (with 98969) | 9.45 | Day
Telehealth Set Up Fee | 583 (with 98969) | 780 (with 98969) | 50 | One time set up fee
Maximum Daily Amount Acute Home Health |  |  | 435.12 | 24 hours, MN to MN
Maximum Daily Amount Long Term Home Health |  |  | 339.48 | 24 hours, MN to MN
Private Duty Nursing Rates
Service Type |  | Revenue Code | Rate | Unit Value
PDN-RN |  | 552 | 36.98 | Hour
PDN-LPN |  | 559 | 27.77 | Hour
PDN-RN (group-per client) |  | 580 | 27.71 | Hour
PDN-LPN (group-per client) |  | 581 | 21.26 | Hour
"Blended" group rate / client* |  | 582 | 27.69 | Hour
* The "blended" rate is available on request for a Home Health Agency that provides Private Duty Nursing to multiple clients at group care settings.  All Private Duty Nursing provided in those settings is billed at the same rate and revenue code for an RN or LPN.
Spreadsheet: 101548d1299660212-data-compilation-sales-calculator-2010
Sheet: Data Entry

 |  |  |  | Sales Executive Pay Plan Calculator
 |  |  |  | Salespersons Name
 |  |  |  | Month/Year
 |  |  |  | [NAME] |  | Type |  | No. Min Comm |  | No. [NAME] |  | Chassis Paid     No.              Profit £ |  |  |  | Comm Paid £
 |  |  |  | Push Cars |  | New |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Pull Cars |  | New |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Motability / VIP Sales |  | New |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | A1 |  | New |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Used, Demo & Ex-Demo |  | Used |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | [NAME] (New/Used) |  | 0 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Overage Used Car 90 Days + |  | Used |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | #N/A
 |  |  |  | Target (Month) |  |  |  | Plan |  | Actual |  | [NAME] |  |  |  | Non Opp's
 |  |  |  | New |  |  |  | #N/A |  | 0 |  | #N/A
 |  |  |  | Used |  |  |  | #N/A |  | 0 |  | #N/A
 |  |  |  |  |  |  |  | #N/A |  | 0 |  | #N/A |  |  |  | 0
 |  |  |  | Sales Target Category Achieved |  |  |  |  |  |  |  |  |  | #N/A |  | #N/A
 |  |  |  | Qualification
 |  |  |  | Offers Created |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | CEI Score |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Failed Mystery Shops |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | F&I PPU Achieved |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Qualification Achieved |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | [NAME] at |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | F&I Performance Paid at |  |  |  |  |  | Link to Sales |  | Yes |  |  |  | #N/A
 |  |  |  | F&I Performance |  | Type |  | % to Pay Comm |  |  |  | No. |  | Penetration % |  | Comm Paid £
 |  |  |  | HP, LP, CH, FL Cases |  | All |  | Total % |  |  |  |  |  | #N/A |  | 0
 |  |  |  | PCP Cases |  | All |  | Line % |  |  |  |  |  | #N/A |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | #N/A
 |  |  |  | Supagard Cases |  | All |  |  |  |  |  |  |  | #N/A |  | 0
 |  |  |  | 36M Warranties |  | Used |  |  |  |  |  |  |  | #N/A |  | 0
 |  |  |  | 24M to 35M Warranties |  |  |  |  |  |  |  |  |  | #N/A |  | 0
 |  |  |  | 12M to 23M Warranties |  |  |  |  |  |  |  |  |  | #N/A |  | 0
 |  |  |  | 3M to 11M Warranties |  |  |  |  |  |  |  |  |  | #N/A |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  | Other |  |  |  | Pass |  | Fail <90% |  | Fail |  |  |  | Commission £
 |  |  |  | CEI (Monthly Bonus) 90% + |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Mystery Shop 95% + |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | Holiday pay YTD £
 |  |  |  | Total Commission for   () |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Commission per car |  | #N/A
Spreadsheet: 9e34ad3a-fc8b-428f-901f-3162c3d26e4b
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 10/25/2014 4:09:22 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
District 37 | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 482831d1475257100-per-diem-calculation-per-diem-calculator
Sheet: Sheet1

Meals Per Diem Calculator |  |  |  | Yellow cell are data entry areas.
Per Diem Eligibility |  | 50
Meals Per Diem Rate
Total | Breakfast | Lunch | Dinner
First Day of Travel |  | Last Day of Travel |  | Meals Per Diem
Date | Departure Time | Date | [NAME]
2016-09-30 00:00:00 |  | 2016-10-15 00:00:00
 |  |  |  |  |  | Conditions:
 |  |  |  |  |  | If employee leaves before 11:00, then added $15.  They should get the Breakfast per diem
 |  |  |  |  |  | If employee leaves before 2:00 PM, then add $30  They should get the Breakfast & Lunch per diem
 |  |  |  |  |  | If employee leaves before 10 PM, then add $50.  They should get the Breakfast per diem
 | Departure Time |  | Arrival time |  |  | If employee arrives after 11:00, then added $15.  They should get the Breakfast per diem
 | After 5:00am |  | Before 10:00am |  |  | If employee arrives after 2:00 PM, then add $30  They should get the Breakfast & Lunch per diem
 | After 5:00pm |  | Before 7:00pm |  |  | If employee arrives after 10 PM, then add $50.  They should get the Breakfast per diem
* Provide the approximate time by selecting from the drop-down list.
 | Departure Day Per Diem |  | Return Day Per Diem
 | Meal Substraction |  | Meal Substraction