tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793577d1661540857-look-for-words-in-vlookip-price-selection
Sheet: SAP Finances

 | Status | Name | SAP Budget | Detailed Budget
 | Open | A1-13366-Casa 32oz Danone ID 2023 | 5877563 | 0
 | Open | Blowmolding System | 900103 | 0
 | Open | Freight Charges | 0 | 0
 | Open | Sales & Use Tax | 0 | 0
 | Open | GPC Plant Labor | 0 | 0
 | Open | Contract Engineering | 0 | 0
 | Open | Extruder | 0 | 0
 | Open | [NAME] (POLY) | 300008 | 0 |  |  | 8
 | Open | Installation - Electric | 0 | 0
 | Open | Installation - Mechanical | 0 | 0
 | Open | Spare Parts | 0 | 0
 | Open | Customs Duties | 0 | 0
 | Open | GTC Mechanical Build | 0 | 0
 | Open | GTC Electrical Build | 0 | 0
 | Open | Downstream Equipment | 546965 | 0
 | Open | Freight Charges | 0 | 0
 | Open | Sales & Use Tax | 0 | 0
 | Open | GPC Plant Labor | 0 | 0
 | Open | Contract Engineering | 0 | 0
 | Open | [NAME] | 0 | 0
 | Open | Line Control Equipment/Panel | 0 | 0
 | Open | Tooling - Trimmer | 0 | 0
 | Open | Trimmer/Demoiler | 0 | 0
 | Open | Conveyor Equipment | 0 | 0
 | Open | Installation - Electric | 0 | 0
 | Open | Building Improvements | 0 | 0
 | Open | Installation - Mechanical | 0 | 0
 | Open | Spare Parts | 0 | 0
 | Open | Customs Duties | 0 | 0
 | Open | GTC Mechanical Build | 0 | 0
 | Open | GTC Electrical Build | 0 | 0
 | Open | Quality Equipment | 310795 | 0
 | Open | Freight Charges | 0 | 0
 | Open | Sales & Use Tax | 0 | 0
 | Open | Contract Engineering | 0 | 0
 | Open | Vision Systems | 0 | 0
 | Open | Leak Detector | 0 | 0
 | Open | Installation - Electric | 0 | 0
 | Open | Installation - Mechanical | 0 | 0
 | Open | Spare Parts | 0 | 0
 | Open | Lab/Quality | 0 | 0
Spreadsheet: 881837d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills-jot
Sheet: March

Monthly Bills Jot
From [NAME] | mortgage | 397.5
 | bills | 257.41
 | pot | 500
 | receipts | 246.72
 | owed | 0
Back to jack | credit | 0 | pay off credit card
Mine | To Bills | 909.4
 | Credit Card ex
 | Receipts | 0
 | To Pot | 0
 | Pay credits
 | Santander
£50 in pot | + | 0
minus |  | 0
 |  | 0
Spreadsheet: 28290d1222348282-how-to-add-count-as-a-column-item-in-pivot-table-copy-of-dthaeh
Sheet: Sheet2

Name | Account
fred | Apple
fred | Pear
fred | Orange
fred | Orange
fred | [NAME]
fred | Mandarin
fred | Satsuma
fred | Mango
fred | Apple
[NAME] | Pear
[NAME] | Orange
[NAME] | Orange
[NAME] | [NAME]
[NAME] | Mandarin
bob | Satsuma
bob | Mango
bob | Apple
bob | Pear
bob | Orange
bob | Orange
bob | [NAME]
bob | Mandarin
bob | Satsuma
bob | Mango
bob | Apple
bob | Pear
bob | Orange
bob | Orange
bob | [NAME]
bob | Mandarin
bob | Satsuma
bob | Mango
bob | Apple
bob | Pear
jane | Orange
jane | Orange
jane | [NAME]
Spreadsheet: d07ea2c6-c68c-4f37-9eff-6c7737962534
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
[NAME] | Test | [NAME] | Valproic Acid, Free and Total, Serum | Valproic Acid, Free and Total, S | FRVPA: Membrane Separation/Immunoassay VPAT: Immunoassay | Plain, Red-Top Tube: Red |  |  | 2 | mL | Container/Tube: Red top [NAME]: 2 mL Collection Instructions: Spin down within 2 hours of draw. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | TOTAL Therapeutic concentration: 40 (trough)-100 (peak) mcg/mL Toxic concentration: > or =120 mcg/mL  FREE Therapeutic concentration: 4-15 mcg/mL Toxic concentration: >15 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
[NAME] | Component | FRVPA | Valproic Acid, Free, Serum | Valproic Acid, Free, S | Membrane Separation/Immunoassay | Plain, Red-Top Tube: Red |  |  | 2 | mL | Container/Tube: Plain, red top [NAME]: 2 mL Collection Instructions: Spin down within 2 hours of draw. | 1.0 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | (See Valproic Acid, Free and Total, test 81771 for reference range) | Monday through Sunday; Varies | Same day/1day | 3 days | 1 | 80164 |  |  | Yes | No
FRVPA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FRVPA | Result | 15886 | Valproic Acid, Free, S | Valproic Acid, Free, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4087-3 | Valproate.free:MCnc:Pt:Ser/Plas:Qn:
[NAME] | Component | VPAT | Valproic Acid, Total, Serum | Valproic Acid, Tot, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). Spin  down and send 1 mL of serum refrigerated. | 0.4 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icteric	Mild OK; Gross reject | Therapeutic concentration: 40(trough)-100(peak) ug/mL Toxic concentration: > or =120 ug/mL | Monday through Sunday; Varies | Same day/1 day | 3 days | 1 | 80164 |  |  | Yes | Yes (order VPA)
VPAT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
VPAT | Result | 8707 | Valproic Acid, Tot, S | Valproic Acid, Tot, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 4086-5 | Valproate:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 5cf7d403-bf27-41a0-add6-3626d876a4ed
Sheet: Brother Fees

[NAME] | Paid | 400
[NAME] |  | 200
[NAME]
[NAME] | Paid | 400
[NAME] | Paid | 400
[NAME] | Paid | 400
[NAME] | Paid | 400
[NAME]
[NAME]
Aatish Jamal | Paid | 400
Spreadsheet: 816837d1675858494-count-unique-value-occuirences-count-unique
Sheet: Sheet1

Name |  | Unique sort
& Soda
& Soda |  | 10 Minute
& Soda |  | [NAME] 007
[NAME] 007 |  | Paco Rabanne
[NAME] 007
[NAME] 007
[NAME] 007
[NAME] 007
[NAME] 007
Paco Rabanne
Paco Rabanne
Paco Rabanne
Paco Rabanne
10 Minute
10 Minute
10 Minute
10 Minute
[NAME] 007
Paco Rabanne
Paco Rabannes1
Spreadsheet: 881720d1729860446-type-matching-named-ranges-lilyw-book-23-365-aligw
Sheet: Actuals

 |  | C1 | C2 | [NAME] | Category | C5 | C6 | C7 | C8 | Type |  | Income |  | Expenses |  | Savings
 |  | 2024-10-19 00:00:00 | Bank | Store 1 | Groceries |  | -20.99 |  |  |  |  | Paychecks/Salary |  | Auto Insurance |  | Education
 |  | 2024-10-18 00:00:00 | Bank | Store 2 | Groceries |  | -22.42 |  |  |  |  | Other Income |  | Automotive |  | Emergency Fund
 |  | 2024-10-18 00:00:00 | Bank | Store 3 | Transfer |  | -587.61 |  |  |  |  | Interest |  | Clothing/Shoes |  | Propane
 |  | 2024-10-18 00:00:00 | Bank | Store 4 | Transfer |  | -2421.3 |  |  |  |  | IRA Deposit |  | CRV Loan |  | Taxes
 |  | 2024-10-17 00:00:00 | Bank | Store 5 | Gasoline/Fuel |  | -18.6 |  |  |  |  | End Month Shortage |  | Electricity |  | Vacation
 |  | 2024-10-17 00:00:00 | Bank | Store 6 | General Merchandise |  | -15.13 |  |  |  |  |  |  | Gasoline/Fuel
 |  | 2024-10-17 00:00:00 | Bank | Store 7 | Transfer |  | 587.61 |  |  |  |  |  |  | General Merchandise
 |  | 2024-10-17 00:00:00 | Bank | Store 8 | Transfer |  | 2421.3 |  |  |  |  |  |  | Gifts
 |  | 2024-10-16 00:00:00 | Bank | Store 9 | Transfer |  | 700 |  |  |  |  |  |  | Groceries
 |  | 2024-10-16 00:00:00 | Bank | Store 10 | Transfer |  | -700 |  |  |  |  |  |  | Healthcare/Medical
 |  | 2024-10-17 00:00:00 | Bank | Salary | Paychecks/Salary |  | 2200 |  |  |  |  |  |  | Home Improvement
 |  | 2024-10-01 00:00:00 | Bank | Trip | Vacation |  | 1200 |  |  |  |  |  |  | Home Insurance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Home Maintenance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Internet
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Kubota Loan
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pets/Pet Care
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Charges/Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Telephone
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Trash Removal
Spreadsheet: 198097d1354651506-dsum-help-dsum
Sheet: Sheet1

Nix Mortgage Corporation
Name | Location | Title | Hire Date | Salary
[NAME] | Atlanta | Account Rep | 2000-11-24 00:00:00 | 40000
[NAME] | Boston | Account Rep | 2001-03-16 00:00:00 | 40000
[NAME] | Atlanta | Account Rep | 2000-11-24 00:00:00 | 40000
Elofson | Miami | Account Rep | 2003-10-31 00:00:00 | 47500
Fernandez | Miami | Account Rep | 2003-10-31 00:00:00 | 47500
George | Miami | Account Rep | 2005-10-31 00:00:00 | 55000
Gillenson | Miami | Account Rep | 2005-10-31 00:00:00 | 55000
[NAME] | Atlanta | Account Rep | 2000-11-24 00:00:00 | 40000
Honey | Atlanta | Account Rep | 2000-11-24 00:00:00 | 65000
Huff | Boston | Account Rep | 2001-03-16 00:00:00 | 40000
Irani | Boston | Account Rep | 2001-03-16 00:00:00 | 49500
Irving | Atlanta | Account Rep | 2000-11-24 00:00:00 | 65000
[NAME] | Chicago | Account Rep | 2000-10-31 00:00:00 | 42500
[NAME] | Chicago | Account Rep | 2001-10-31 00:00:00 | 47500
[NAME] | Boston | Account Rep | 2001-03-16 00:00:00 | 40000
Jones | Boston | Account Rep | 2001-03-16 00:00:00 | 49500
Jones | Boston | Account Rep | 2001-03-16 00:00:00 | 45000
Jones | Chicago | Account Rep | 2000-10-31 00:00:00 | 42500
Kantor | Chicago | Account Rep | 2001-10-31 00:00:00 | 47500
Kaufman | Chicago | Account Rep | 2002-10-31 00:00:00 | 38500
Labossiere | Miami | Account Rep | 2003-10-31 00:00:00 | 47500
Ledon | Miami | Account Rep | 2005-10-31 00:00:00 | 55000
Manin | Boston | Account Rep | 2001-03-16 00:00:00 | 49500
[NAME] | Chicago | Account Rep | 2002-10-31 00:00:00 | 38500
Milgrom | Boston | Account Rep | 2001-03-16 00:00:00 | 45000
[NAME] | Chicago | Account Rep | 2000-10-31 00:00:00 | 42500
[NAME] | Boston | Account Rep | 2001-03-16 00:00:00 | 45000
[NAME] | Chicago | Account Rep | 2001-10-31 00:00:00 | 47500
Smith | Atlanta | Account Rep | 2000-11-24 00:00:00 | 65000
Smith | Chicago | Account Rep | 2002-10-31 00:00:00 | 38500
[NAME] | Chicago | Manager | 2001-03-16 00:00:00 | 52000
Coulter | Atlanta | Manager | 2000-11-24 00:00:00 | 100000
[NAME] | Miami | Manager | 2004-10-31 00:00:00 | 75000
Geisler | Miami | Manager | 2004-10-31 00:00:00 | 75000
Goodman | Atlanta | Manager | 2000-11-24 00:00:00 | 100000
[NAME] | Boston | Manager | 2001-03-16 00:00:00 | 57500
Jones | Chicago | Manager | 2001-03-16 00:00:00 | 52000
Lang | Boston | Manager | 2001-03-16 00:00:00 | 57500
Larson | Miami | Manager | 2004-10-31 00:00:00 | 75000
Milgrom | Boston | Manager | 2001-03-16 00:00:00 | 57500
Mills | Chicago | Manager | 2001-03-16 00:00:00 | 52000
Adams | Atlanta | Trainee | 2000-11-24 00:00:00 | 29500
[NAME] | Atlanta | Trainee | 2000-11-24 00:00:00 | 29500
Gold | Atlanta | Trainee | 2000-11-24 00:00:00 | 29500
Name | Location | Title | Hire Date | Salary
 |  | Manager
Summary Statistics
 | Total Salary of Managers
 | Average Salary of Managers in Boston
 | Total Salary of Account Reps in Miami
 | Average Salary of Account Reps
 | Number of Chicago Employees
 | Number of Trainees in Atlanta
Spreadsheet: 164212d1340693970-pivot-tables-book1
Sheet: Sheet4

Count of Group | Column Labels
Row Labels | Baseball | Basketball | Football | Hockey | tennis |  | Name | Group 1 | Group 2 | Group 3 | Group 4 | Group 5
[NAME] | 1 | 1 | 1 | 1 | 1
[NAME] |  | 1
Mark |  |  | 1 |  | 1
Fred |  |  | 1 | 1
Spreadsheet: 158364d1338201696-nested-if-formula-nested-if-formula
Sheet: Nested if formula

situation 1:
situation 2:
situation 3:
situation 4:
situation 5:
situation 6:
situation 7:
What I want to obtain is: if B is empty, get C, if C is empty get D, if D is empty, get E
I'm applying the following formula: =IF(B1<>"",B1,IF(C1<>"",D1,IF(D1<>"",E1)))
 | result | expected result
situation 1: |  | B 1
situation 2: |  | C 2
situation 3: |  | D 3
situation 4: |  | E 4
situation 5: |  | B 5
situation 6: |  | C 6
situation 7: |  | B 7
Spreadsheet: 72581d1273260334-formatting-logic-issue-automated-kwex-stat
Sheet: Stat

Date | Transit Time | A | Ship site name | [NAME] | PTP# | Service Level | HAWB# | APPTSET REQ? Y/N | Driver Ref# | origin/code | Zone | Origin Region | [NAME] | Phone# | ALT # | Consignee/Address | City | State | [NAME] | Dest/code | Zone | Region | Product/Type | L | W | H | Model# (Product ID) | Weight/(lb) | Packages | Value | Customer/PO | Serial# | RA# | Call/1 | Call/2 | Call/3 | Scheduled Date | Actual Date | POD/Delivery/Date | Status/-/In/process,/scheduled,/closed | Action/Needed///Update | Delay Codes | Today's Date | SN# [NAME] Picked up
2010-04-20 00:00:00 | 13 | A | Far East | 7072 |  |  | DL34761098 |  | 8047144587 |  |  |  | KATHY PFANNENSTIEL | 785) 213 1540 | 0 | 1515 NW GAGE | Topeka | KS | 66618 |  |  |  | 40" | 42 | 12 | 27 | LS40BHPNB/XAA | 50 | PL34753715 | 1099 | 4006472190 | BH40HCNPA01560B | 702946700 |  |  |  |  |  |  |  | 2ND DAY SERVICE DO NOT DEL W/O PICKING UP RTN UNIT AT TIME OF SWAP (KWEX18907 B2B) *APPT. REQUIRED* |  | 2010-05-07 14:21:24
1900-01-01 00:00:00 |  | B | 0 | 0 |  |  | N/A |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4006472190 | BH40HCNPA01560B | 702946700 |  |  |  |  |  |  |  | 0 |  | 2010-05-07 14:21:24
Spreadsheet: 887025d1737108151-robust-index-match-w-non-tabular-data-dynamic_report_pivotby
Sheet: Dynamic Report

 | Desc | Type | Total | 202403 | 202402 | 202401
1 | Green Thing | pos_quantity_this_year | 517 | 454 | 58 | 5
1 | Green Thing | pos_sales_this_year | 19363 | 10442 | 1334 | 7587
2 | Red Thing | pos_quantity_this_year | 980 | 544 | 430 | 6
2 | Red Thing | pos_sales_this_year | 26098 | 12512 | 9890 | 3696
3 | Blue Thing | pos_quantity_this_year | 6689 | 5588 | 1001 | 100
3 | Blue Thing | pos_sales_this_year | 210879 | 128524 | 23023 | 59332
4 | Orange Thing | pos_quantity_this_year | 217006 | 212358 | 4598 | 50
4 | Orange Thing | pos_sales_this_year | 4995873 | 4884234 | 105754 | 5885
Spreadsheet: 1f8ff133-a4c2-4e36-a6ca-156aa56d1d24
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 15. HOUSING FINANCE SEASONAL FACTORS, BY STATE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ;  Number of Commitments ; |  |  | Original | A2433086W | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
New South Wales ;  Value of Commitments ; |  |  | Original | A2433087X | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Victoria ;  Number of Commitments ; |  |  | Original | A2433088A | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Victoria ;  Value of Commitments ; |  |  | Original | A2433089C | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Queensland ;  Number of Commitments ; |  |  | Original | A2433090L | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Queensland ;  Value of Commitments ; |  |  | Original | A2433091R | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
South Australia ;  Number of Commitments ; |  |  | Original | A2433092T | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
South Australia ;  Value of Commitments ; |  |  | Original | A2433093V | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Western Australia ;  Number of Commitments ; |  |  | Original | A2433094W | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Western Australia ;  Value of Commitments ; |  |  | Original | A2433095X | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Tasmania ;  Number of Commitments ; |  |  | Original | A2433096A | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Tasmania ;  Value of Commitments ; |  |  | Original | A2433097C | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Northern Territory ;  Number of Commitments ; |  |  | Original | A2433098F | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Northern Territory ;  Value of Commitments ; |  |  | Original | A2433099J | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Number of Commitments ; |  |  | Original | A2433100F | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Value of Commitments ; |  |  | Original | A2433101J | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 97156d1296400101-can-i-get-sheet-name-from-its-position-in-workbook-sheetnames-grouped
Sheet: LargeTable

Student | English | Maths
[NAME] | 90 | 85
[NAME] | 0 | 0
[NAME] | 60 | 55
[NAME] | 52 | Pass A
Anne | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
Spreadsheet: holden_salisbury__12313__September 2001 tranny
Sheet: Sheet1

 | Desk | Data
 | EPMI-ST-SW |  | EPMI-ST-WHOURLY |  | Total Sum of Gross MW | Total Sum of Total Amt
Act Date | Sum of Gross MW | Sum of Total Amt | Sum of Gross MW | Sum of Total Amt
2001-09-01 00:00:00 | -650 | -149250 |  |  | -650 | -149250
2001-09-02 00:00:00 | -90 | 0 |  |  | -90 | 0
2001-09-03 00:00:00 | -390 | 0 |  |  | -390 | 0
2001-09-04 00:00:00 | -1270 | 0 |  |  | -1270 | 0
2001-09-05 00:00:00 | -470 | 0 |  |  | -470 | 0
2001-09-06 00:00:00 | -1320 | 0 |  |  | -1320 | 0
2001-09-07 00:00:00 | -1320 | 0 |  |  | -1320 | 0
2001-09-08 00:00:00 | -1320 | 0 |  |  | -1320 | 0
2001-09-09 00:00:00 | 0 | 0 |  |  | 0 | 0
2001-09-10 00:00:00 | -240 | 0 |  |  | -240 | 0
2001-09-11 00:00:00 | -720 | 0 |  |  | -720 | 0
2001-09-12 00:00:00 | -1810 | 0 |  |  | -1810 | 0
2001-09-13 00:00:00 | -1338 | 0 |  |  | -1338 | 0
2001-09-14 00:00:00 | -2118 | 0 |  |  | -2118 | 0
2001-09-15 00:00:00 | -2118 | 0 |  |  | -2118 | 0
2001-09-16 00:00:00 | 0 | 0 |  |  | 0 | 0
2001-09-17 00:00:00 | 0 | 0 |  |  | 0 | 0
2001-09-18 00:00:00 | -290 | 0 |  |  | -290 | 0
2001-09-19 00:00:00 | -440 | 0 |  |  | -440 | 0
2001-09-20 00:00:00 | -200 | 0 |  |  | -200 | 0
2001-09-21 00:00:00 | -640 | 0 |  |  | -640 | 0
2001-09-22 00:00:00 | -640 | 0 |  |  | -640 | 0
2001-09-23 00:00:00 | 0 | 0 |  |  | 0 | 0
2001-09-24 00:00:00 | -1120 | 0 |  |  | -1120 | 0
2001-09-25 00:00:00 | -1940 | 0 |  |  | -1940 | 0
2001-09-26 00:00:00 | -1344 | 0 |  |  | -1344 | 0
2001-09-27 00:00:00 | -1410 | 0 |  |  | -1410 | 0
2001-09-28 00:00:00 | -1410 | 0 |  |  | -1410 | 0
2001-09-29 00:00:00 | -1120 | 0 |  |  | -1120 | 0
2001-09-30 00:00:00 | 0 | 0 | -976 | -1991.04 | -976 | -1991.04
Grand Total | -25728 | -149250 | -976 | -1991.04 | -26704 | -151241.04
 | ST SW |  | ST W Hourly
MW | 25728 |  | 976
Loss charge MW/h | 0.58169712402 |  | 0.58169712402
Annuity for losses
 | See deal # 800630.2 |  | See deal # 800630.1
Spreadsheet: 156122d1337183667-formula-for-cell-count-matrixed-data-and-result-going-to-sheet-2-matrix-data-count_ver2
Sheet: sheet 2

OUTPUT
 | GREEN | WHITE | YELLOW
BOX A | 3 | 1 | 2
BOX B | 2 | 0 | 0
BOX C | 3 | 0 | 1
BOX D | 1 | 2 | 1
Spreadsheet: 2a9ba4d0-b43e-46ae-8b61-22397f794ac0
Sheet: Sheet1

 | Division of Insurance
Quarterly Variance Report for Quarter _______ Year_______.
Company Name:
Item | Budget | Actual | Change | % Change | Detailed Explanation of Variances over +/- 10%
Total Revenue
Total Expenses
Total Administrative Expenses
Net Underwriting Gain/(Loss)
Quarterly Net Income
Year-to-date Net Income
YTD Dividends Paid
Current Assets/Current Liab
Prop & Equip/Net Worth
Members, end of period
Member Months to date
YTD Revenue PMPM
YTD Net Med & Hosp Exp PMPM
YTD Administration Exp PMPM
YTD Net Income PMPM
Commercial Medical Loss Ratio
Medicare Medical [NAME]
Medicaid Medical [NAME]
Total Net Worth, end of period
Other changes to Net Worth (explain below)
Minimum Statutory Net Worth Requirement (Please enter the higher of the statutory minimum per §10-16-411(1), C.R.S. or  the CALRBC amount per §10-16-411(2), C.R.S.
[NAME]
Please note that accurate completion of this document assists the Division of Insurance financial section in reviewing the company's financial fluctuations.  Detailed explanations of variances will help to provide necessary advance information to the Division of Insurance analysts, which would otherwise have to be requested separately from the company.
Quarterly comparisons of actual results versus budgeted amounts, including explanations of all variances of greater than 10%, are due with each quarterly financial statement filing.
Send to the attention of:  Financial Affairs Section
 |  |  |  |  | 2011-12-01 00:00:00
Inquiries: DORA INS_FinancialAffairs <[EMAIL]
Spreadsheet: 101493d1299606889-vlookup-problem-practice-payroll
Sheet: Salary

25.58 |  |  |  |  |  |  |  |  | 3 days, 8:00:00 | 80
 |  |  |  |  |  |  |  |  | 3 days, 0:00:00 | 72
 |  |  |  |  |  |  |  |  | 2 days, 16:00:00 | 64
 |  |  |  |  |  |  |  |  | 2 days, 8:00:00 | 56
 |  |  |  |  |  |  |  |  | 2 days, 0:00:00 | 48
 |  |  |  |  |  |  |  |  | 1 day, 16:00:00 | 40
 |  |  |  |  |  |  |  |  | 1 day, 8:00:00 | 32
 |  |  |  |  |  |  |  |  | 1 day, 0:00:00 | 24
 |  |  |  |  |  |  |  |  | 16:00:00 | 16
 |  |  |  |  |  |  |  |  | 8:00:00 | 8
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2197 | -2135 |  | -25
2 | -2276 | -2135 | -4 | -25
3 | -2197 | -2135 |  | -25
4 | -2147 | -2135 |  | -25
5 | -2142 | -2135 |  | -25
6 | -2152 | -2135 |  | -25
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114286.65
2002-01-06 00:00:00
CBS Volume
 |  |  | 48091
Spreadsheet: 0a0fbe0a-6c9f-47e7-9fa4-ebc6d91b3cf0
Sheet: Contracted Services

CONTRACTED SERVICES
Assign a number or letter to each contract to be placed in the management plan behind tab V8. Clearly display the number or letter on the copy of the contract for matching purposes.
List below all contracted or paid services for administrative and operating functions not performed by any organization personnel.
Cost for contracted services may be charged over the period of the contract.
Copies of all contracts must be on file at FNS. Sponsors are responsible to ensure updated copies are submitted to FNS annually or whenever the contract is revised or renewed.
Bank charges may be listed here.  Include a copy of bank agreement of applicable charges to be placed in the management plan with FNS.
Contracted services must be directly related to the CACFP or the expense will be disallowed.
Number or Letter for each contract listed for FNS Matching purposes | Type of Service | Company Name | Contract Begin Date | Contract End Date | Contract/Policy Number if Applicable | Annual Cost to CACFP | % Allocated to CACFP | Total Annual Cost to CACFP
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  |  | Total Contracted Services