tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47805d1246981359-help-with-when-the-end-result-is-value-food-intake-journal
Sheet: Sunday

 | POINTS CALCULATOR
 | Bonus Points ==>
 | Daily Points Allowance ==> | 20 | Points Used Today ==> |  | #N/A | Points Remaining ==> |  | #N/A
FIRST LETTER OF FOOD | Breakfast ==> | #N/A | Lunch ==> | #N/A | Dinner==> | #N/A | Snacks ==> | #N/A
 |  | SERVING SIZE | QTY | CALORIES | FAT [NAME] | [NAME] | CALCULATED POINTS | ACTUAL POINTS | ADDITIONAL NOTES:
 | Breakfast
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 | Snacks
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 | Lunch
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 | Snacks
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 | Dinner
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 | Snacks
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
Spreadsheet: 118712d1313941982-find-first-empty-cell-with-a-formula-that-adjusts-references-when-inserting-columns-finding-the-first-empty-cell
Sheet: Sheet1

List of information | [NAME] giving the row number of the first empty cell in the list . [NAME] range typed in R1C1 form with typed in numbers to define rows and columns. | The same list of information | The same formula giving the row number of the first empty cell in the list. Except, now the formula range typed in R1C1 form is using COLUMN() functions to get column numbers.
Can |  | Can
anybody |  | anybody
please |  | please
help |  | help
me |  | me
with |  | with
this |  | this
problem? |  | problem?
 | PS: I use =FALSE instead of ="" inside the INDIRECT function in order to find the first truly empty cell instead of just the first blank.
Spreadsheet: c65abf78-4d20-4f66-9cca-9c34d91b96dd
Sheet: Alignment

Alignment
A high quality assessment should be...Aligned
1a. [NAME]):
1a. Indicate the Colorado Academic Standards and Grade Level Expectations evaluated by the Assessment:
Colorado Academic Standards Online | Reference sheet explaining how to code the Standards and Grade Level Expectations
1a. Indicate the intended DOK range of the Grade Level Expectations:    (Check all that apply.) |  | DOK 1 |  | DOK 2 |  | DOK 3 |  | DOK 4
1a. Indicate the intended DOK of the assessment (Check all that apply.) |  | DOK 1 |  | DOK 2 |  | DOK 3 |  | DOK 4
General DOK Levels reference Sheet |  | DOK Art |  | DOK ELA |  | DOK Math and Science
1b. Describe the content knowledge/concepts assessed by the set of items or the performance task:
1c. List the skills/performance assessed (what are students expected to do?):
1d. To what extent do you see a strong content match between the set of items reviewed or the task and the corresponding Colorado Academic Standard/s?  Use the definitions to select your rating.   You MUST justify your rating below. |  | Full match – all tasks or items fully address or exceed the relevant skills and knowledge described in the corresponding state standard/s. |  | Close match – most tasks or items address the relevant skills and knowledge described in the corresponding state standard/s. |  | Partial match – many tasks or items partially address the skills and knowledge described in the corresponding state standard/s. |  | Minimal match – some tasks or items match some relevant skills and knowledge described in the corresponding state standard/s.
 |  | No match – task or most items are not related to the skills and knowledge described in the corresponding state standard/s.
1d. Justification of Overall Content Match Rating:  Please provide evidence from both the standards and assessment to support your response:   (Your response should be detailed and include examples)
1e. Are the set of items or tasks reviewed as cognitively challenging as the grade level expectations?  Use the definitions below to select your rating. |  | More rigorous – most items or the tasks reviewed are at a higher DOK level than the range indicated for the grade level expectations. |  | Similar rigor – most items or the task reviewed are similar to the DOK range indicated for the grade level expectations. |  | Less rigor – most items or the task reviewed are lower than the DOK range indicated for the grade level expectations.
1e. Justification of Overall Cognitive Match :   Please provide evidence from both the grade level expectations and assessment to support your response:
Overall Strengths and Suggestions Regarding Alignment
Spreadsheet: 122584d1316998246-sumproduct-appliances
Sheet: Sheet2

Selected | Item | Brand | Model | Dimensions | Additional Informtion | Location | MSRP Price | Discount | Tax | Final Price | Sale Viewed | Date Purchased | Delivery Date | [NAME]
Yes | Dishwasher | KitchenAid | KUDE60FXSS |  |  | Canadian Appliances |  |  | 0 | 0
No | Dishwasher | KitchenAid | KUDE60FXSS |  |  | Appliances Canada | 1480 | 0.1 | 221.985 | 1701.885
No | Dishwasher | Jenn-Air | JDB3600AWS |  |  | Canadian Appliances |  |  | 0 | 0
No | Dishwasher | Jenn-Air | JDB3600AWS |  |  | Appliances Canada | 1400 | 0.1 | 209.985 | 1609.885
Yes | Fridge | KitchenAid | KFCS22EVMS | 72" X 35.5 |  | Canadian Appliances |  |  | 0 | 0
No | Fridge | KitchenAid | KFCS22EVMS | 72" X 35.5 |  | Appliances Canada | 3150 | 0.1 | 472.485 | 3622.385
No | Fridge | Jenn-Air | JFC2089WES |  | 69" | Canadian Appliances |  |  | 0 | 0
Yes | Fridge | Jenn-Air | JFC2089WES |  | 69" | Appliances Canada | 3200 | 0.1 | 479.985 | 3679.885
No | Fridge | Jenn-Air | [NAME] |  | 72" | Not Viewed |  |  | 0 | 0
No | Fridge | Jenn-Air | [NAME] |  | 72" | Not Viewed |  |  | 0 | 0
No | Oven | KitchenAid | KEMS308SSS |  |  | Canadian Appliances |  |  | 0 | 0
No | Oven | KitchenAid | KEMS308SSS |  |  | Appliances Canada | 4800 | 0.1 | 719.9849999999999 | 5519.884999999999
No | Oven | Jenn-Air | [NAME] |  | Dual Fan | Canadian Appliances |  |  | 0 | 0
No | Oven | Jenn-Air | [NAME] |  | Dual Fan | Appliances Canada | 5800 | 0.1 | 869.9849999999999 | 6669.884999999999
No | Oven | Jenn-Air | JMW2430WS |  | Multi-Mode Convestion | Not Viewed |  |  | 0 | 0
No | Oven | Jenn-Air | JMW2327WS |  | Multi-Mode Convestion | Not Viewed |  |  | 0 | 0
No | Oven | Jenn-Air | JMW2427WS |  | Standard | Not Viewed |  |  | 0 | 0
 | Jenn-Air Dishwasher | 1609.885
 | Jenn-Air Fridge | 3679.885
 | Jenn-Air Oven | 6669.884999999999
 |  | 11959.655
Spreadsheet: 774980d1648747245-list-top-5-scores-and-identifying-them-sample
Sheet: Sheet1

 |  | 85-100 TON DOWNTIME CODES |  |  |  |  |  |  |  |  |  | TOTAL A CART DT | CODE |  | 85-100 TON TOP 5 DOWNTIMES
 |  | CODE | NAME | C 1 | C 2 | C 3 | C 4 | C 5 | C 6 | LV 5 | LV 6 |  |  |  | CODE | NAME | MIN
 | COMMON | 1 | Power Outage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2 | Scheduled Downtime | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 4 |  | 50
 |  | 3 | Waiting for Maintenace | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 16 |  | 50
 |  | 4 | Unscheduled Maintenance | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 15
 |  | 5 | No Labor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 12
 |  | 6 | Material | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 7 | Waiting for Quality | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 8 | Quality Concern | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 9 | Start-Up | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 10 | Meeting / Breaks | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0
 |  | 11 | Lunch | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 12 | Cleanup | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 13 | Changeover | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 14 | Trial | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SB CARTRIDGE SPECIFIC | 15 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 16 |  | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 17 |  | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0
 |  | 18 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 19 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 20 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 21 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 22 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 23 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 24 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 25 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 26 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 27 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 28 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 29 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 30 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 165 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 165
Spreadsheet: 881932d1730189181-turn-off-conditional-formatting-if-a-value-is-entered-in-next-column-copy-of-just-checking-spread-sheet-ugly
Sheet: Lists

Sensor Locations |  | Service Areas |  | Module Type |  | Outcome |  | Property Type |  | Care Call |  | Activity Monitors
Bedroom 1 (Movement & Door) |  | Hospital Team |  | Single |  | Cost Saving |  | Independent Living |  | A.M 30 Mins |  | Clients Chair - Lounge
Bedroom 2 (Movement & Door) |  | Connect |  | Mulitple |  | Cost Avoidance |  | Supported Living |  | A.M 60 Mins |  | Walking Frame - Bedroom
Bedroom 3 (Movement & Door ) |  | City Wellbeing Team |  |  |  | Cost Increase |  | Residential Care |  | [NAME] 30 Mins |  | Toilet Cistern
Bedroom 4 (Movement & Door) |  | Community Occupational Therapy |  |  |  | Avoided Nursing Home Admission |  | Nursing Home |  | [NAME] 60 Mins |  | Under Dinning Table
Bedroom 5 (Movement & Door) |  | Reablement Service |  |  |  | Nursing Home Admission |  |  |  | Dinner 30 Mins |  | Microwave
Staff Door (Door) |  | LD & Neurodivergent Team |  |  |  | Residential Admission |  |  |  | Dinner 60 Mins |  | Fridge
Hallway ( Movement) |  | Mental Wellbeing Team |  |  |  | Avoided Residential Admission |  |  |  | Bed 30 Mins |  | [NAME]
Bathroom 1 (Movement) |  |  |  |  |  | Avoided Hospital Admission |  |  |  | Bed 60 Mins |  | Walking Frame Lounge
Bathroom 2 (Movement)
Kitchen 1 (Movement)
[NAME] (Movement)
Lounge 1 (movement)
Lounge 2 (Movement)
Front Door 1 (Door)
Back Door (Door)
Front Door 2 (Door)
Back Door 2 (door)
Spreadsheet: 726193d1617104142-vlookup-that-picks-up-the-dates-against-each-of-the-sites-book2-etaf
Sheet: Sheet1

Site Name | Date |  |  | NAME | DATE
Addison Road |  |  |  | 36-52 Soprano Way | 05.03.2021
Addison Road |  |  |  | 72-92 Soprano Way | 05.03.2021
Addison Road |  |  |  | [NAME], Chitterne | 15.03.2021
36-52 Soprano Way |  |  |  | [NAME], [NAME] | 15.03.2021
36-52 Soprano Way |  |  |  | Addison Road | 25.03.2021
[NAME], College Road Estate |  |  |  | Alcock Crest, Alcock Crest Estate | 12.03.2021
36-52 Soprano Way |  |  |  | Aldeburgh Place, [NAME] | 15.03.2021
36-52 Soprano Way |  |  |  | [NAME], College Road Estate | 09.03.2021
[NAME], College Road Estate |  |  |  | [NAME], Mascroft Road | 08.03.2021
Spreadsheet: 725411d1616670550-edit-formula-not-to-consider-blank-cells-with-formulas-problem
Sheet: Sheet2

Order no. | Product |  | Order no. | Product | Component | Notes | Quantiity | Cost |  | Product | Component | Country | Value | Item | Box | Label | Bag |  |  | Component | Component | Component | Box | Label | Bag
MO-1 | Beverage | - |  |  |  | - | - | - |  | Beverage | [Item] Tea | - | - | Beverage | Box A | [NAME] | Bag S |  | Beverage
MO-1 | Food | - |  |  |  | - | - | - |  | Beverage | [Item] Juice | - | - | Flower | [NAME] | [NAME] | Bag M |  | Flower
MO-2 | Flower | - |  |  |  | - | - | - |  | Flower | [Item] Tulip | - | - | Furniture | Box C | [NAME] | Bag L |  | Furniture
MO-3 | Furniture | - |  |  |  | - | - | - |  | Furniture | [Item] Table | - | - | Food | Box D | [NAME] | Bag XL |  | Food
MO-4 | Food | - |  |  |  | - | - | - |  | Furniture | [Item] Chair | - | - | Pets | Box A | [NAME] | Bag M |  | Pets
MO-5 | Food | - |  |  |  | - | - | - |  | Furniture | [Item] Couch | - | -
MO-6 | Flower | - |  |  |  | - | - | - |  | Food | [Item] Bacon | - | -
[NAME] | Flower | - |  |  |  | - | - | - |  | Food | [Item] Egg | - | -
[NAME] | Beverage | - |  |  |  | - | - | - |  | Pets | [Item] Cat | - | -
MO-8 | Furniture | - |  |  |  | - | - | -
MO-9 | Pets | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
 |  | - |  |  |  | - | - | -
Spreadsheet: 778759d1651299396-unable-to-get-index-match-to-make-data-from-one-worksheet-to-to-a-summary-worksheet-index-match-sample-file-aligw
Sheet: BT

This is the worksheet INTO which I want to pull data using INDEX/Match
to come FROM the Combined worksheet
Account Source | Account Number | Bank Statement Order Number | Date |  |  |  | INDEX MATCH |  |  | FILTER
BT Investors Choice | 1026 |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  | 2020-07-01 00:00:00
BT Investors Choice | 2180 | 1 | 2020-10-01 00:00:00 |  |  |  |  |  |  | 1 | 2020-10-01 00:00:00
BT Investors Choice | 2180 | 2 | 2020-01-01 00:00:00 |  |  |  |  |  |  | 2 | 2020-01-01 00:00:00
BT Investors Choice | 2180 | 3 | 2020-04-01 00:00:00 |  |  |  |  |  |  | 3 | 2020-04-01 00:00:00
BT Investors Choice | 2180 | 4 | 2021-06-30 00:00:00 |  |  |  |  |  |  | 4 | 2021-06-30 00:00:00
I am using the suggested formulae:
 |  | Expected Value
 |  | 1
 |  | 1
What am I doing incorrrectly in EACH formula?
Index |  | Expected Value
 |  | 0
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | Blank
Match |  | Expected Value
 |  | 0
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | Blank
 |  | Expected Value
 |  | 0
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | Blank
Spreadsheet: d3be3e8a-cfde-42ce-8174-e3163cc1309c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7796 | 39858 | Mikel | Garmendia | ESP | 0 | 00:21:06 | 00:02:09 | 00:39:51 | 00:02:17 | 00:13:02 | 1 | 01:18:24
7796 | 49501 | [NAME] | [NAME] | ESP | 0 | 00:23:17 | 00:02:15 | 00:41:55 | 00:02:37 | 00:14:35 | 2 | 01:24:38
Spreadsheet: 600377d1543655468-formula-to-create-table-or-list-based-on-team-members-sample-2-
Sheet: Overview

Org | ID | Project Name | Assignees | Status | Submitter | Size | Type | helper (Hide) |  | 2018-11-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSERT HERE | Hours
Dept 1 | ABC-123 | write xmas cards |  | consult |  |  | Write
 |  | [NAME] | liz |  |  |  |  |  |  |  | 2
 |  | VXD2 | lyn |  |  |  |  |  |  |  |  | 1 | 2
 |  | VXD3
 |  | VXD4
 |  | UX1
 |  | UX2
 |  | UX3
 |  | [NAME] | may |  |  |  |  |  |  |  | 6
 |  | Producer
 |  | Mgr 1
 |  | Mgr 2
Dept 2 | ABC-345 | write new years cards |  | scoping |  |  | write
 |  | [NAME] | [NAME] |  |  |  |  |  |  |  | 3 | 3
 |  | VXD2 | liz |  |  |  |  |  |  |  | 10 | 9
 |  | VXD3
 |  | VXD4
 |  | UX1 | [NAME] |  |  |  |  |  |  |  | 5 | 5
 |  | UX2
 |  | UX3
 |  | [NAME] | kate |  |  |  |  |  |  |  | 2 | 2
 |  | Producer
 |  | GPX Mgr 1 | bob |  |  |  |  |  |  |  | 2 | 1
 |  | GPX Mgr 2
Dep 3 | ABC-678 | design paper |  | in progress |  | M | Design
 |  | [NAME] | liz |  |  |  |  |  |  |  | 3 | 6
 |  | VXD2 | lyn |  |  |  |  |  |  |  | 3 | 5
 |  | VXD3
 |  | VXD4
 |  | UX1 | [NAME] |  |  |  |  |  |  |  | 4 | 4
 |  | UX2
 |  | UX3
 |  | [NAME]
 |  | Producer
 |  | GPX Mgr 1
 |  | GPX Mgr 2
Dep 4 | ABC-910 | envelope |  | in progress | crbrow | S | Design
 |  | [NAME] | liz |  |  |  |  |  |  |  | 12 | 12
 |  | VXD2
 |  | VXD3 | [NAME] |  |  |  |  |  |  |  | 2 | 6
 |  | VXD4 | lyn |  |  |  |  |  |  |  | 4 | 2
 |  | UX1 | [NAME] |  |  |  |  |  |  |  | 1 | 1
 |  | UX2 | [NAME] |  |  |  |  |  |  |  | 2 | 2
 |  | UX3
 |  | [NAME]
 |  | Producer
 |  | GPX Mgr 1 | [NAME] |  |  |  |  |  |  |  | 1 | 1
 |  | GPX Mgr 2
Spreadsheet: 674625d1587962057-concatenate-cells-using-a-varying-identifier-in-a-different-field-forumsample
Sheet: Forum Post

Last Name | First Name | Address |  |  |  | City | Zip (RA) | State (RA)
SHIFFIS | RUSTY | 10262   FARM ROAD 2240 |  |  |  | WALTON | 78000 | IL
JILSON | VALERIE | 1035   WASHBURN PRAIRIE RD |  |  |  | WALTON | 78000 | IL
SHRUCK | MEGAN | 106   [NAME] |  |  |  | WALTON | 78000 | IL
BEANS | CONNIE | 107  W PINEVILLE RD |  |  |  | WALTON | 78000 | IL
LINDE | [NAME] | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
LINDE | JANIS | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
WENDRIX | [NAME] | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | MELISSA | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | DORTHY | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | JOHNIE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
SLACK-WENDRIX | LOUISE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
BARNER | GREGORY | 128  N OLD WIRE RD |  |  |  | WALTON | 78000 | IL
STEPHENSON | CONNIE | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
STEPHENSON | WILLIS | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
RESULTS NEEDED
Last Name | First Name | Address |  |  |  | City | Zip (RA) | State (RA)
JILSON |  | 1035   WASHBURN PRAIRIE RD |  |  |  | WALTON | 78000 | IL
SHRUCK |  | 106   [NAME] |  |  |  | WALTON | 78000 | IL
BEANS |  | 107  W PINEVILLE RD |  |  |  | WALTON | 78000 | IL
LINDE |  | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
WENDRIX |  | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX |  | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
SLACK-WENDRIX |  | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
BARNER |  | 128  N OLD WIRE RD |  |  |  | WALTON | 78000 | IL
STEPHENSON |  | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
Spreadsheet: 877062d1723732182-calculated-item-in-pivot-table-returning-unexpected-rows-calculated_item_example-foxsmolder-
Sheet: Pivot

 | State Program | Element | Sum of Actual | Sum of Budget | Sum of Budget Variance
 | [NAME] | Cost | 4588 | 5000 | -412
 | [NAME] | Revenue | 13565 | 15000 | -1435
 | [NAME] | Operating Margin | 8977 | 10000 | -1023
 | [NAME] | Cost | 3600 | 5000 | -1400
 | [NAME] | Revenue | 9100 | 15000 | -5900
 | [NAME] | Operating Margin | 5500 | 10000 | -4500
 | Ohio Hotdoggers | Cost | 4875 | 5000 | -125
 | Ohio Hotdoggers | Revenue | 16509 | 15000 | 1509
 | Ohio Hotdoggers | Operating Margin | 11634 | 10000 | 1634
 | Ohio Little Leaguers | Cost | 4955 | 5000 | -45
 | Ohio Little Leaguers | Revenue | 15777 | 15000 | 777
 | Ohio Little Leaguers | Operating Margin | 10822 | 10000 | 822
Spreadsheet: 456662d1460986707-sumifs-with-a-wildcard-as-part-of-the-criteria-book1-002-
Sheet: Sheet1

Date/Time | Financial REF | Fee |  |  |  |  | Total Fees
2016-04-04 15:04:19 | G4BMXR7B1D55 | 5.2 |  |  |  | 2016-04-04 00:00:00 | =SUMIFs(C2:C30,A2:A30,G2,B2:B30,
2016-04-04 15:04:23 | G4BMXRB2SI2E | 5.2
2016-04-04 15:04:27 | RL17E73H22G-G64BMXRFb | 3.4
2016-04-04 15:04:35 | G4BMXRN1CF3N | 0.85
2016-04-04 15:04:42 | G4BMXRU1CL6P | 3
2016-04-04 15:04:43 | G4BMXRV219PA | 0.35
2016-04-04 15:04:43 | G4BMXRV3IFLL | 1.55
2016-04-04 15:04:47 | G4BMXRZ810Q6 | 0.4
2016-04-04 15:04:47 | G4BMXRZ71CF3 | 5.2
2016-04-04 15:04:50 | [NAME] | 2.15
2016-04-04 15:04:54 | G4BMXS661GK8 | 0.65
2016-04-04 15:04:56 | G4BMXS8819Q9 | 0.1
2016-04-04 15:05:16 | X4BMXSS41ZO4 | 2.35
2016-04-04 15:05:17 | G4BMXST4824A | 1.75
2016-04-04 15:05:21 | G4BMXSX11JDC | 0.1
2016-04-04 15:05:24 | X4BMXT011SSC | 2.6
2016-04-04 15:05:28 | G4BMXT481ZI9 | 3.4
2016-04-04 15:05:32 | [NAME] | 2.5
2016-04-04 15:05:34 | G4BMXTA81TV9 | 5.8
2016-04-04 15:05:38 | X4BMXTE27493 | 2.6
2016-04-04 15:05:45 | G4BMXTL31NNN | 1.7
2016-04-04 15:05:49 | G4BMXTP4S612 | 5.2
2016-04-04 15:05:53 | [NAME] | 10.5
2016-04-04 15:05:53 | G4BMXTT31CW9 | 2.2
2016-04-04 15:05:56 | RU35PF6I8VZ1-G64BMXTWb | 4.4
2016-04-04 15:05:57 | G4BMXTX96924 | 2.6
2016-04-04 15:05:58 | G4BMXTY14NYY | 5.25
2016-04-04 15:06:11 | [NAME] | 2.6
2016-04-04 15:06:12 | X4BMXUC5K918 | 0.85
Spreadsheet: 695510d1600255769-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets
Sheet: 02.09.20

Ref | Description | Total | Total Consumed Hrs
Number | Under Section | Qty | Man Power | Machinery
 | Section-A
1212 | Fiiling | 6 | 10 | 6
3152 | Flooring | 25 | 10 | 14
 | Section-B
2510 | Trimming | 14 | 11 | 14
3451 | Concreting | 12 | 21 | 10
 | Section-C
2141 | Cutting | 10 | 12.5 | 41
3524 | Demolition | 11 | 8 | 30
Spreadsheet: 184094d1349138468-detecting-percentage-increase-or-entered-values-test-file-for-excell-forum
Sheet: Sheet1

 |  | Percentage |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter $
 |  | Current Year | 2013 | 2014 | 2015 | 2016 | 2017
 |  |  | 0.05 | 0.1 |  |  |  |  | <- Enter percentage
 | Pension | 6.57
 | Welfare | 8.22
 | Total
Spreadsheet: 015447fb-b20c-4f78-b38c-b2e6c12b6de6
Sheet: Sarah

 |  |  |  | FY10/11 |  |  |  |  | FY11/12 |  |  |  |  | FY12/13 |  |  |  |  | FY 13/14
 | Account | Dept | Description | Adopted Budget | Working Budget | Actual Spending | Actual / Adopted budget | Balance | Adopted Budget | Working Budget | Actual Spending | Actual / Adopted budget | Balance | Adopted Budget | Working Budget | Actual Spending | Actual / Adopted budget | Balance | Budget Change Validation
[NAME] | 100_205000_6600_54210_000 | Classified Senate | Non-Instr. Supplies/Materia | 100 | 100 | 98.31 |  | 1.69 | 100 | 43 | 11.37 |  | 31.63 | 100 | 100 | 0 |  | 100
[NAME] | 100_205000_6600_55115_000 | Classified Senate | Food Services | 0 | 230 | 230 | 0 | 0
[NAME] | 100_205000_6600_55205_000 | Classified Senate | Travel, Conference- Other Intl | 271 | 178 | 177.9 |  | 0.1 | 271 | 592 | 591.95 |  | 0.05 | 271 | 271 | 0 |  | 271
[NAME] | 100_205000_6600_55240_000 | Classified Senate | Mileage | 200 | 572 | 571.2 |  | 0.8 | 200 | 0 | 0 |  | 0 | 200 | 200 | 0 |  | 200
[NAME] | 100_206300_6750_52310_819 | MC-Classified Senate | Hourly Classified Salaries | 1000 | 0 | 0 |  | 0 | 1000 | 0 | 0 |  | 0 | 1000 | 1000 | 0 |  | 1000
[NAME] | 100_206300_6750_54210_819 | MC-Classified Senate | Non-Instr. Supplies/Materia | 500 | 500 | 488.48 |  | 11.52 | 500 | 375 | 374.5 |  | 0.5 | 500 | 500 | 0 |  | 500
[NAME] | 100_206300_6750_55115_819 | MC-Classified Senate | Food Services | 1500 | 2500 | 2499.74 |  | 0.26 | 1500 | 483 | 482.44 |  | 0.56 | 1500 | 1500 | 0 |  | 1500
[NAME] | 100_206300_6750_55205_819 | MC-Classified Senate | Travel, Conference- Other Intl | 1500 | 1500 | 1500 |  | 0 | 1500 | 3642 | 3642 |  | 0 | 1500 | 1500 | 197.05 |  | 1302.95
[NAME]