tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128936d1321365577-grand-total-without-row-pivot-column-excel-2003-sample_pivot_data
Sheet: Raw

[NAME] | Survey Counter | Score | Agent
0 | 1 | [NAME] | Agent 6
0 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 1
0 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 5
1 | 1 | [NAME] | Agent 4
1 | 1 | [NAME] | Agent 2
1 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 3
1 | 1 | [NAME] | Agent 1
0 | 1 | [NAME] | Agent 9
0 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 3
1 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 4
1 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 4
1 | 1 | [NAME] | Agent 7
1 | 1 | [NAME] | Agent 5
1 | 1 | [NAME] | Agent 9
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 3
1 | 1 | [NAME] | Agent 6
0 | 1 | [NAME] | Agent 10
1 | 1 | [NAME] | Agent 10
1 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 8
0 | 1 | [NAME] | Agent 6
0 | 1 | [NAME] | Agent 7
1 | 1 | [NAME] | Agent 7
0 | 1 | [NAME] | Agent 5
1 | 1 | [NAME] | Agent 6
1 | 1 | [NAME] | Agent 1
1 | 1 | [NAME] | Agent 3
1 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 6
1 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 7
1 | 1 | [NAME] | Agent 7
0 | 1 | [NAME] | Agent 10
1 | 1 | [NAME] | Agent 4
1 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 6
1 | 1 | [NAME] | Agent 9
0 | 1 | [NAME] | Agent 2
1 | 1 | [NAME] | Agent 2
1 | 1 | [NAME] | Agent 1
1 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 6
1 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 6
0 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 6
1 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 10
1 | 1 | [NAME] | Agent 2
0 | 1 | [NAME] | Agent 8
1 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 7
0 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 4
0 | 1 | [NAME] | Agent 3
0 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 10
0 | 1 | [NAME] | Agent 1
1 | 1 | [NAME] | Agent 5
0 | 1 | [NAME] | Agent 9
0 | 1 | [NAME] | Agent 4
1 | 1 | [NAME] | Agent 7
0 | 1 | [NAME] | Agent 1
1 | 1 | [NAME] | Agent 9
1 | 1 | [NAME] | Agent 7
Spreadsheet: a908384a-f388-4d58-b514-40133a1044bb
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
LCMC | Test | LCMC | Identification, M.chelonae and M.abscessus,PCR ([NAME] Only) | Id,M.chelonae and M.abcessus,PCR |  |  |  |  |  |  | This test is for billing purposes only. This is not an orderable test. |  |  | This test is for billing purposes only. This is not an orderable test. |  |  |  | 1 | 87149 |  |  |  |  | Rochester
LCMC | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 465517d1465732186-pivot-table-help-book45-amended
Sheet: New Pivot

Region | (All)
Customer | (All)
Row Labels | RED KPI 1 | RED KPI 2 | RED KPI 3
[NAME] | 7 | 0 | 3
[NAME] T | 17 | 21 | 4
[NAME] A | 26 | 17 | 7
Laurne L | 9 | 9 | 3
[NAME] O | 20 | 7 | 8
[NAME] | 8 | 6 | 8
Ricky R | 10 | 11 | 6
Sundeep T | 7 | 7 | 1
Grand Total | 104 | 78 | 40
Spreadsheet: 217558d1362102341-need-help-with-if-statement-formula-example
Sheet: Sheet1

100 | data | data | data | 0
101 | data | data | data | 0
102 | data | data | data | 1
103 | data | data | data | 0
104 | data | data | data | 1
105 | data | data | data | 0
106 | data | data | data | 1
107 | data | data | data | 0
108 | data | data | data | 1
109 | data | data | data | 1
110 | data | data | data | 0
111 | data | data | data | 0
112 | data | data | data | 1
113 | data | data | data | 0
114 | data | data | data | 1
115 | data | data | data | 0
Spreadsheet: 83b01a32-8a06-4867-9317-5dfda8f030f9
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
FH1N1 | Test | FH1N1 | Influenza A H1N1 (2009) Real-Time RT-PCR | Influenza A H1N1 (2009) | Real-Time PCR (RT-PCR) |  |  |  |  |  | Nasal, nasopharyngeal or throat swab, or nasal aspirates in 3 mL of viral transport media, M4 media or V-C-M medium (green cap) tube or equivalent (UTM) shipped refrigerated. Note: 1. Swab must be sterile Dacron, nylon, or rayon with plastic shafts. Place swab in sterile viral transport media containing protein stabilizer, antibiotics to inhibit bacterial fungal growth, and buffer solution (eg, UTM, VCM, [NAME], M5, [NAME] and other media intended to transport Chlamydia, Mycoplasma or viruses). 2. Do not use calcium alginate swabs; only sterile swabs are acceptable. | 0.35 mL | Specimens other than	Nasal, nasopharyngeal swab, nasal aspirate Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  Not Detected  Test Performed By:  Focus Diagnostics, Inc.                                         5785 Corporate Avenue                                         Cypress, CA   90630-4750 | Monday through Sunday | 1-2 days | 3-4 days | 1 | 87502 |  |  |  |  | Focus Diagnositics, Inc.
FH1N1 | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FH1N1 | Order Question | Z1738 | Source |  | Plain Text
FH1N1 | Result | Z1738 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FH1N1 | Result | [NAME] | Influenza A RNA | Influenza A RNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FH1N1 | Result | Z1740 | 2009 Influenza H1 Gene | 2009 Influenza H1 Gene | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: FamilyIndex

Family Index
2004-2005
Metric | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total | Price for 2004-2005 | Price per search
TOTAL
Sessions | 55 | 19 | 127 | 376 | 151 | 61 | 29 | 95 | 369 | 274 | 121 | 11
Searches | 29 | 6 | 76 | 247 | 388 | 168 | 115 | 239 | 267 | 166 | 72 | 9 |  | 313
Spreadsheet: 218107d1362350312-assistance-with-array-or-advanced-filter-please-lmgtfy-4
Sheet: c

 | Group Name :
 | Group Count :
 | Birthday Range
 | Start Date:
 | End Date:
Parent's
First Name | Child | Child's dob
Spreadsheet: 56224d1256310673-using-if-and-round-in-same-calculation-example-1-
Sheet: Sheet1

Cost | 10% | Customer Cost Each | Qty | Total Cost
800 | 80 | 880 | 1 | 880
10 | 1 | 11 | 2 | 22
0.05 | 0.01 | 0.06 | 10 | 0.6
Spreadsheet: 98215d1297213968-pulling-data-based-off-a-date-entered-test-spreadsheet
Sheet: Daily

2011-02-08 00:00:00
Location | Widget1 | Widget2 | Widget3 | Total | % Forecast
Factory 1 | 1 | 2 | 1 | 4 | 2
Factory 2 | 1 | 2 | 2 | 5 | 1.666666666666667
Factory 3 | 1 | 0 | 0 | 1 | 0.5
Factory 4 | 2 | 0 | 2 | 4 | 2
Factory 5 | 3 | 0 | 1 | 4 | 1.333333333333333
Factory 6 | 0 | 4 | 0 | 4 | 2
Factory 7 | 2 | 0 | 2 | 4 | 2
Factory 8 | 0 | 0 | 3 | 3 | 1
Factory 9 | 0 | 2 | 0 | 2 | 1
Factory 10 | 1 | 4 | 0 | 5 | 1.666666666666667
Factory 11 | 0 | 0 | 2 | 2 | 1
ALL Factories | 11 | 14 | 13 | 38 | 1.461538461538461
Spreadsheet: 738108d1624849665-all-cells-in-row-follow-lead-a-column-cell-explination-workbook-1-ans
Sheet: Attendance sheet ADJUSTED

Name |  | Shift | Day 1 | Day 2 | Day 3 | Day 4
 | 2 |  | P | A | P | P |  |  |  | This list has been adjusted with everything being in alphbetical order on the roster list (2)
 | 3 |  | P | P | P | P
 | 4
 | 5 |  | P | P | P | A |  |  |  | As you can see when the roster list changed, the pre entered daily attendance entries did not "follow " the names they were orginally assigen to
 | 6
 | 7 |  | P | P | P | A
 | 8
 | 9 |  | P | P | P | P
 | 10
 | 11
 | 12
 | 13
 | 14 |  | A | P | P | P |  |  |  | As a result the data is no longer good and it would be imposible for someone to figure out the actuall attendance any longer.
 | 15 |  | P | P | P | P
 | 16
 | 17 |  | P | A | P | P
 | 18 |  |  |  |  |  |  |  |  | I need a way to make the information in columns D - G to "follow" the people in column A  as adjustments are made to the roster list tab
 | 19 |  | A | P | P | A
 | 20 |  |  |  |  |  |  |  |  | and new people are added in and old people are taken out or if the list is simply sorted alphabetically and the names rearanged.
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27 |  | P | P | P | A
 | 28
 | 29
 | 30
 | 31 |  | P | P | P | P
 | 32
Spreadsheet: 78935d1279204892-lookup-pre-excel7-issue-help
Sheet: Sheet1

 |  |  |  |  |  |  | Percentage of Data held
 |  |  | Description
 | 1 | G | Thing
 |  |  |  |  |  |  | If the description (colC) is Red, then take number of reds and divide it by total number of descriptions ([NAME])
 | 2 | R | Thing
 | 3 | R | Thing
 | 4 | R | Thing
 | 5 | N/A | Thing
 | 6 | R | Thing
 | 7 | G | Thing
 | 8 | Y | Thing
 | 9 | R | Thing
 | 10 | N/A | Thing
 |  |  | …….
Spreadsheet: 221324d1363469275-how-to-calucate-the-gratuity-gratuity
Sheet: Sheet3 (2)

Staff Number | Name | join date |  | service | basic | Gratuity |  |  |  |  |  |  | yr | Gratuity
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
101 | a | 2000-01-01 00:00:00 |  |  | 4000 | 75760 |  |  |  |  |  |  | 2
102 | b | 2005-02-01 00:00:00 |  |  | 4200 |  |  |  |  |  |  |  | 3
103 | c | 1999-01-01 00:00:00 |  |  | 3200 |  |  |  |  |  |  |  | 4
105 | d | 2003-12-31 00:00:00 |  |  | 4200 |  |  |  |  |  |  |  | 5
105 | e | 2009-09-09 00:00:00 |  |  | 3500 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 13
Spreadsheet: 110731d1307365472-automatically-moving-data-between-cells-sheets-in-excel-nbss-operations-subgroup-tasks
Sheet: References

 |  | Sub-Group |  | Status |  | Raised
 |  | Operations
 |  | Administration |  | Logged |  | [NAME]
 |  | IM&T |  | Completed |  | Alison Dorras
 |  | Laboratory |  | Suspended |  | [NAME]
 |  | QA & Policy |  | Rejected |  | [NAME]
 |  | Finance |  | Deleted |  | [NAME]
 |  | Education |  | In progress |  | [NAME]
 |  | External QA |  | To be Actioned |  | [NAME]
 |  | Communications & marketing |  | Awaiting Policy |  | [NAME]
 |  | Project Team |  | Awaiting standard |  | [NAME]
 |  | Project Board
 |  | Sonography & Counselling
 |  | Surgical & capacity
Spreadsheet: 684761d1593526763-remove-blanks-from-data-vaildation-lists-test-enviro-eie
Sheet: Data Feed Sheet

People |  | People no Blanks |  |  | Account Types
First Name | Last Name |  |  |  | Cash | Investment | Insurance | Liability | Stock Options | Notes Receivable
 |  |  |  |  | Checking | 529 Plan | Group Long Term Disability | Automobile
 |  |  |  |  | Savings | Fixed | Group Short Term Disability | Credit Card
 |  |  |  |  | Money Market | Variable | Mortgage Protection (Disability) | Debt Consolidation
 |  |  |  |  | T-Bills | Deferred Compensation | Other Disability | Line of Credit
 |  |  |  |  | CDs | Health Savings Account | Personal Long Term Disability | Other
 |  |  |  |  |  | IRA | Personal Shot Term Disability | Personal
 |  |  |  |  |  | Money Purchase | Retirement Protection (Disability) | Student Loan
 |  |  |  |  |  | Pension | Group Life Insurance | Home Equity Loan
 |  |  |  |  |  | Profit Sharing | Term Life Insurance | Mortgage
 |  |  |  |  |  | [NAME] 401(k) | Universal Life Insurance | Reverse Mortgage
 |  |  |  |  |  | [NAME] 403(b) | Variable Universal Life Insurance
 |  |  |  |  |  | SEP | Variable Whole Life Insurance
Joint |  |  |  |  |  | Traditional 401(k) | Whole Life Insurance
 |  |  |  |  |  | Traditional 403(b) | Other Life Insurance
 |  |  |  |  |  | Other Qualified Retirement Account | Long-Term Care Policy
 |  |  |  |  |  | Roth IRA | Medical Insurance
 |  |  |  |  |  | Taxable Investment | Auto Insurance
 |  |  |  |  |  |  | Boat Insurance
 |  |  |  |  |  |  | Condo/Townhome Insurance
 |  |  |  |  |  |  | Flood Insurance
 |  |  |  |  |  |  | Homeowner's Insurance
 |  |  |  |  |  |  | Rental Insurance
Spreadsheet: 08c04032-0b6c-47b3-b038-6fa840d65f8a
Sheet: 4a-AFR-Final

Expelled and at Risk Student Services Grant AFR
AFR - FINAL
District/BOCES:
School:
Facility:
 |  |  | Year 1 | Year 2 | Year 3 | Year 4
 |  |  | Actual Expenditures | Actual Expenditures | Actual Expenditures | Actual Expenditures
 |  | Amount Requested
 |  | INSTRUCTIONAL SERVICES
 | 1 | Salaries (0100)
 | 2 | Employee Benefits (0200)
 | 3 | Purchased Professional & Technical Services (0300)
 | 4 | Other Purchased Services (0500)
 | 5 | Supplies (0600)
 | 6 | Non-Capital Equipment (0735)
 |  | SUPPORT SERVICES
 | 7 | Salaries (0100)
 | 8 | Employee Benefits (0200)
 | 9 | Purchased Professional & Technical Services (0300)
 | 10 | Other Purchased Services (0500)
 | 11 | Supplies (0600)
 | 12 | Non-Capital Equipment (0735)
 |  | ADMINISTRATIVE SUPPORT
 | 13 | Salaries (0100)
 | 14 | Employee Benefits (0200)
 | 15 | Purchased Professional & Technical Services (0300)
 | 16 | Other Purchased Services (0500)
 | 17 | Supplies (0600)
 | 18 | Non-Capital Equipment (0735)
 | 19 | Total Budget
 | 20 | Unobligated funds as of June 30th-MUST BE RETURNED TO CDE-See sheet 4-Annual Financial Report
 | 21 | Pupils Served By Program
 | 22 | Amount Expended per pupil served
Spreadsheet: 847378d1698333056-subtract-formula-required-formula-required
Sheet: Sheet1

Current Value | Previous Value | ANSWER
-114 | 0 | -114
-1968 | -3 | -1965
2 | 0 | 2
-3 | -5 | -2
1000 | 0 | 1000
1000 | 500 | 500
2000 | 3000 | -1000
-20 | 500 | -480
3000 | 1000 | 2000
-40 | -50 | -10
-5000 | 3000 | -2000
2000 | 2000 | 0
-200 | -600 | -400
2269 | -1181 | 1088
Spreadsheet: 704701d1605708437-vlookup-and-if-statement-combination-for-a-date-test-formulas-v3
Sheet: MATRIX

 | POST | NAME | PHONE NUMBER | FLIGHT | TRIP # | LICENSE | FC/FS | FSC | RFL
 |  | BIG B |  |  |  |  | 2021-03-31 00:00:00
 |  | 1
 |  | RICH | [PHONE] |  | 111 | 2021-10-24 00:00:00 | 2021-03-31 00:00:00
 |  | DAN | [PHONE] |  | 222 | 2021-09-07 00:00:00 |  |  | 2021-07-31 00:00:00
 |  | GOL | [PHONE] |  | 333 | 2021-03-28 00:00:00 |  |  | 2021-07-31 00:00:00
 | g-2 | MOR | [PHONE] |  | 444 | 2021-02-08 00:00:00 |  |  | 2020-11-30 00:00:00
 |  | D'MAR | [PHONE] |  |  | 2021-05-14 00:00:00 |  |  | 2021-03-31 00:00:00
 |  | LAN | [PHONE] |  | 777 | 2021-04-09 00:00:00
 |  | HOUS | [PHONE] |  | 888
 |  | ARIA | [PHONE] |  | 999 |  |  |  | 2021-03-31 00:00:00
 |  | ELEMENT 2
 |  | MCDO | [PHONE] |  | 1212 | 2020-03-01 00:00:00 | 2020-04-30 00:00:00 | 2020-04-30 00:00:00
 |  | TYL | [PHONE] |  | 1313 | 2020-03-13 00:00:00 |  |  | 2021-03-31 00:00:00
 |  | CAMP | [PHONE] |  | 1414 | 2021-03-20 00:00:00 |  |  | 2021-07-08 00:00:00
 |  | KASP | [PHONE] |  | 1515 | 2021-06-04 00:00:00 |  |  | 2021-07-09 00:00:00
 |  | RAY | [PHONE] |  | 1616 | 2021-06-03 00:00:00 |  |  | 2021-05-31 00:00:00
Spreadsheet: hunter_shively__12739__EnovateDPR0117
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | -183.3784664399997 | 10.61723725999802 | -50.20831987300177 | -168.1440735500014
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
YTD 2000 EARNINGS ESTIMATE
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Office of the Chairman
Total Commercial
Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Capital Charge Offset |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes capital charge, direct, and allocated expenses
Spreadsheet: 55969d1256127299-how-to-show-users-in-groups-from-report-example2-1-
Sheet: Sheet1

Table 1
Group | User
Group1 | user1
Group2 | user2
Group3 | user3
Group4 | user4
Group5 | user5
Group1 | [NAME]
Group2 | user7
Group3 | user8
Group4 | [NAME]
Group5 | user10
Group1 | User4
Group2 | [NAME]
Group3 | [NAME]
Group4 | User10
Group5 | User3
Table 2
 | User1 | User2 | User3 | User4 | [NAME] | [NAME] | User7 | User8 | [NAME] | User10
Group1 | Yes |  |  | Yes |  | Yes
Group2 |  | Yes |  |  |  | Yes | Yes
Group3 |  |  | Yes |  |  |  |  | Yes | Yes
Group4 |  |  |  | Yes |  |  |  |  | Yes | Yes
Group5 |  |  | Yes |  | Yes |  |  |  |  | Yes
Spreadsheet: daren_farmer__5936__Kermit Change 14th
Sheet: Noms

TO: | [NAME] |  | Effective Date |  |  | PHONE: | (713) 853-9272
 | ENRON NORTH AMERICA |  | 2000-06-14 00:00:00 |  |  | FAX: | (713) 646-2391
 |  |  |  |  |  | E-MAIL: | [EMAIL]
FROM: | JAN SVAJIAN |  |  |  |  | PHONE: | (405) 552-8163
 | DEVON ENERGY CORPORATION |  |  |  |  | FAX: | (405) 552-4664
 |  |  |  |  |  | E-MAIL: | [EMAIL]
 |  |  | VOLUME |  | DBQ |  | DBQ |  | EXCESS
 | CDP NAME & METER NUMBER |  | AVAILABLE |  | % |  | AVAILABLE |  | AMOUNT
 | [NAME] (90289) |  | 466 |  | 0.75
 | [NAME] Sat #3 (K-332) |  | 52 |  | 0.75
 | Baird WE 1312 (K-351) |  | 45 |  | 0.75
 | KCC 359 Battery ([NAME]) |  | 44 |  | 0.75
 | SKEU 108 Battery |  | 3516 |  | 0.75
 | State Walton #5 (90337) |  | 183 |  | 0.75
 | Baird #1257 (90339) |  | 203 |  | 0.75
 | Baird #1875 (90329) |  | 97 |  | 0.75
 | Baird #1954 (90327) |  | 179 |  | 0.75
 | Baird #1955 (90328) |  | 201 |  | 0.75
 | H.E. Lovett #2 (90348) |  | 141 |  | 0.75
 | State Walton #1 (90336) |  | 181 |  | 0.75
 | Baird #1382 (90338) |  | 190 |  | 0.75
 | [NAME] (90341) |  | 260 |  | 0.75
 | [NAME] (90340) |  | 372 |  | 0.75
 | [NAME] (90342) |  | 75 |  | 0.75
 | Baird #1381 (90353 |  | 162 |  | 0.75
 | SKEU Bass Operated Holt Unit |  | 512 |  | 0.75
 | KEYSTONE PLANT TAILGATE MMBTU/D
Spreadsheet: 53779d1253709523-excel-2007-conditional-formatting-website-edition
Sheet: Sheet3

NESCAFE CAPPU Unswt MMBFRV01 | NESCAFE CAPPU Unswt MMBFRV01-1 | NESCAFE CAPPU Unswt MMBFRV04 UK | NESCAFE CAPPU Skinny Unswt MMBFSV01-2 | NESCAFE CAPPU Swt MMBFSV05-1 UK | NESCAFE CAPPU Intenso MMBFSV09 | NESCAFE CAPPU Latte Unswt MMBFON09 | NESCAFE CAPPU Latte Unswt MMBFON09-1 | NESCAFE CAPPU [NAME] MMBFON10 | NESCAFE CAPPU [NAME] MMBFON10-1 | NESCAFE CAPPU DcfUnswt MMBFRD01-1 | NESCAFE CAPPU [NAME] MMBFSD04 | NESCAFE CAPPU [NAME]-1 | NESCAFE CAPPU Mocha MMBFON11 | NESCAFE CAPPU Mocha MMBFON11-1 | NESCAFE CAPPU Vanilla MMBFON12 | NESCAFE CAPPU Vanilla MMBFON12-1 | Nescafé Capp Hazelnut MMBFON23-1 | NESCAFE CAPPU Caramel MMBFNO14-3 | NESCAFE CAPPU Chocolate MMBFON15 | NESCAFE CAPPU Irish Cream MMBFON17 | NESCAFE CAPPU Amaretto MMBFON18-1 | NESCAFE LTMAC Iced MIBFON01 | MIX-O-CHOC VC131-2 Non HVO | AERO Hot Chocolate Catering | NESTLE AERO Hot Choc Instant 702kg GB | AERO Hot Chocolate System VC170-1 | Hot Chocolate Vending VC132-1 | AERO Hot Chocolate Mint | AERO Add Milk Hot Chocolate 840kg GB | [NAME] | [NAME] | NESCAFE Chocofreddo MMBMOV01-1 | [NAME]
MMBFRV01 | MMBFRV01-1 | MMBFRV04 | MMBFSV01-2 | MMBFSV05-1 | MMBFSV09 | MMBFON09 | MMBFON09-1 | MMBFON10 | MMBFON10-1 | MMBFRD01-1 | MMBFSD04 | MMBFOV01-1 | MMBFON11 | MMBFON11-1 | MMBFON12 | MMBFON12-1 | MMBFON23-1 | MMBFON14-3 | MMBFON15 | MMBFON17 | MMBFON18-1 | MIBFON01 | [NAME] | VC176 | VC176-1 | VC170-1 | VC132-1 | VC177 | VC178 | CMD3US01 | CMD3US02 | MMBMOV01-1 | New
43060527 | 43182687 | 43188370 | 43213158 | 43188371 | 43121401 | 43060458 | 43182360 | 43060459 | 43182348 | 43182365 | 43131369 | 43155305 | 36901474 | 43182347 | 36901470 | 43182342 | 43182343 | 43182340 | 36901475 | 43050355 | 43182341 | 43106547 | 43125550 | 36902216 | 12035822 & 43098373 | 43143872 | 43125348 | 43036766 | 43050085 | 43165040 | 43165004 | 43143438 | 43213592
Spreadsheet: 122876d1317220722-sort-columns-not-redundant-example
Sheet: Sheet1

 | COLUMN 1 | COLUMN 2 |  |  | COLUMN 1 | COLUMN 2
 | A | 1 |  |  | A | 1
 | A | 2 |  |  | B | 4
 | A | 3 |  |  | C | 7
 | B | 4 |  |  | D | 8
 | B | 5 |  |  | A | 2
 | B | 6 |  |  | B | 5
 | C | 7 |  |  | D | 9
 | D | 8 |  |  | A | 3
 | D | 9 |  |  | B | 6
Spreadsheet: 713215d1610599209-drop-down-selection-to-populate-all-related-accounts-formula-help-test-sample
Sheet: Arrears

 |  |  |  |  | account | member
 |  |  |  |  | 1999001111 | 11111111
 |  |  |  |  | 1999001312 | 45555
 |  |  |  |  | 2001000345 | 34343434
 |  |  |  |  | 2012000888 | 22222222
 |  |  |  |  | 2001000347 | 1111111
 |  |  |  |  | 1996001111 | 45555
 |  |  |  |  | 2020000020 | 22222222
 |  |  |  |  | 1975002222 | 11111111
 |  |  |  |  | 1970001212 | 45555
Spreadsheet: b84b1e11-faab-4733-a4e0-be089231409b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6420 | 39168 | Viktor | Korchagin | RUS | 118 | [NAME] | 00:00:00 | 00:24:57 | 00:00:00 | 00:16:20 | 1 | 00:53:31
6420 | 25301 | [NAME] | [NAME] | RUS | 117 | 00:12:33 | 00:00:00 | 00:26:24 | 00:00:00 | 00:18:04 | 2 | 00:57:01
6420 | 46233 | [NAME] | Lindqvist | SWE | 116 | 00:14:22 | 00:00:00 | 00:33:34 | 00:00:00 | 00:21:35 | 3 | 01:09:32
6420 | 46523 | [NAME] | [NAME] | SWE | 115 | 00:14:01 | 00:00:00 | 00:34:46 | 00:00:00 | [NAME] | 4 | 01:10:03
Spreadsheet: 151388d1334880610-pulling-data-from-one-sheet-to-another-that-meets-certain-criteria-camp-sign-up-spreadsheet-1-
Sheet: Payment Sheet

 | Name | Total Amount Owed | Amount Paid | Amount Left
1
2
3
4
5
6
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
32
33
34
35
36
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -582808 | -589587
2 | -491131 | -493683
3 | -483505 | -493167
4 | -445803 | -487144
5 | -518969 | -516271
6 | -574375 | -598988
7 | -558264 | -565744
8 | -579105 | -609898
9 | -573367 | -599107
10 | -609561 | -607106
11 | -611554 | -604165
12 | -604577 | -604385
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 78487
2002-03-12 00:00:00
CBS Dollars
 |  |  | 277487