tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 20

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-20 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1602 |  | 1948 |  | 67694 |  |  |  |  |  | 19 | 1 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2 | 18
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7076 |  | 8043 |  | 67694 |  |  |  |  |  | 20 | 3 | 17 |  |  | 15
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 20 | 4 | 16 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 18 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2776 |  | 3161 |  | 67694 |  |  |  |  |  | 21 | 6 | 17 |  |  | 22
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 20 | 7 | 17 |  |  | 15
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 24 | 8 | 18 |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 9 | 18 |  |  | 20
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 18991 |  | 20950 |  | 67694 |  |  |  |  |  | 27 | 15 | 19 |  |  | 16
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 21 | 35 | 17 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68915 | 0 |  |  |  |  | 20 | 39 | 16 |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2152 |  | 2453 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1683 |  | 1993 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 16642 |  | 19765 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2660 |  | 3079 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4724 |  | 5414 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6046 |  | 6767 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1367 |  | 1680 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 52 |  | 56 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 859920d1708141458-sum-across-multiple-columns-meeting-3-criteria-v-month-on-month-balances-demo
Sheet: Summary

 |  | 2023-04-30 00:00:00 | 2024-01-31 00:00:00 | Total
 | Income
Main Heading | - Auctions
Sub Heading | Auction | -6006.17 | -59239.85
Sub Heading | AutoKart |  | -779.51
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!B3)*(T!F3:I3=Summary!A7)))
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!C3)*(T!F3:I3=Summary!A7)))
 | Auction | -6006.17 | -59239.85
 | AutoKart |  | -779.51
 | Could you pls. help me pull the data from (Sum from all the column meeting conditions) from "T" worksheet based on following 3 criteria
 | 1 | Main Heading
 | 2 | Sub Heading
 | 3 | Month Criteria
Spreadsheet: 859350d1707758698-count-instances-of-different-words-in-a-column-book1
Sheet: Sheet1

USA
USA
CDN
USA
GBR
USA
CDN
MEX
CDN
CDN
USA
GBR
MEX
Spreadsheet: 23100d1212514085-vlookup-comparison-between-tabs-comparisonform
Sheet: C

www.abc.com/def.htm www.abc.com/def.htm() |  |  | Good | 3
www.def.com/ghi.htm (www.def.com/ghi.htm) |  |  | Bad | 2
www.ghi.com/jkl.htm (www.ghi.com/jkl.htm) |  |  | Ok | 1
www.jkl.com (www.jkl.com) |  |  | Good | 3
www.mno.com/por.htm (www.mno.com/por.htm) |  |  | Bad | 2
[NAME] (www.qrs.com/stu.htm) |  |  | Ok | 1
www.abc.com/abc.htm (www.abc.com/abc.htm) |  |  | Good | 3
[NAME] (www.def.com/def.htm) |  |  | Bad | 2
www.ghi.com/ghi.htm (www.ghi.com/ghi.htm) |  |  | Ok | 1
Spreadsheet: 90598d1290372908-generating-multi-ple-worksheets-from-a-single-master-worksheet-attn2010
Sheet: BP

NB
Spreadsheet: 80595d1280820320-list-of-names-report-of-unique-entries-book2
Sheet: Sheet1

Name
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Spreadsheet: 757376d1638219107-cell-value-from-multiple-sheets-to-be-presented-in-master-sheet-pt2-new-microsoft-excel-worksheet-2-
Sheet: X05122021

Country | A
Poland | [NAME]
U.K. | [NAME]
Italy | [NAME]
France | [NAME]
Germany | [NAME]
Greece | [NAME]
Spain | Martin
Russia | [NAME]
Malta | [NAME]
Austria | [NAME]
Spreadsheet: 865850d1712831474-excel-omits-adjacent-cells-fix-test-excel-1-aligw
Sheet: Data Validation

Type List | Category List
Credit | Income
Debit | Reimbursement
Transfer | Present
 | Misc
 | Food
 | Shopping (Grocery)
 | Shopping (Recreational)
 | Shopping ([NAME])
 | Transport
 | Business
 | School
 | Entertainment
 | Entertainment (Subscriptions)
 | Events
 | Travel
 | Medical
 | Living Expenses (Misc)
 | Living Expenses (Board)
 | [NAME] (Gifts)
 | Misc (Reimbursement)
 | Misc (Other)
 | [NAME] (Account Transfer)
 | Misc (Savings)
Spreadsheet: chris_germany__2961__sit_penalty
Sheet: Sheet1

Date | Broadrun Gas sent to Pool | Gas Sent to [NAME] | Actual burned by [NAME] | SIT injection | SIT Withdrawal | Enron thought SIT withdrawals were allowed these days | TCO EBB postings that allowed SIT withdrawals these days | Days that true-ups were not done because Enron thought SIT withdrawals were allowed | Penalty Gas Per TCO
2000-02-01 00:00:00 | 17753 | 4500 | 4290
2000-02-02 00:00:00 | 17753 | 4500 | 4327
2000-02-03 00:00:00 | 0 | 22500 | 22429 |  |  | x | x | x
2000-02-04 00:00:00 | 17753 | 4500 | 4680 |  |  | x |  | x
2000-02-05 00:00:00 | 17753 | 4500 | 4809 |  |  | x |  | x
2000-02-06 00:00:00 | 17753 | 4500 | 4954 |  |  | x |  | x
2000-02-07 00:00:00 | 17753 | 4500 | 4469 |  |  | x |  | x
2000-02-08 00:00:00 | 17753 | 4500 | 4167 |  |  | x |  | x
2000-02-09 00:00:00 | 0 | 21500 | 22745 |  |  | x |  | x | 0 | *
2000-02-10 00:00:00 | 3640 | 6500 | 5498 |  |  | x |  | x
2000-02-11 00:00:00 | 5684 | 4500 | 4508 |  |  | x |  | x
2000-02-12 00:00:00 | 5684 | 4500 | 4938 |  |  | x |  | x
2000-02-13 00:00:00 | 5684 | 4500 | 4834 |  |  | x |  | x
2000-02-14 00:00:00 | 5684 | 4500 | 4522 |  |  | x |  | x
2000-02-15 00:00:00 | 0 | 4500 | 4638 |  |  | x | x | x | 0
2000-02-16 00:00:00 | 3632 | 8045 | 8595 |  |  | x | x | x | 0
2000-02-17 00:00:00 | 0 | 26436 | 25710
2000-02-18 00:00:00 | 4597 | 22950 | 23935 |  |  |  |  |  | 0 | **
2000-02-19 00:00:00 | 13692 | 5000 | 4631
2000-02-20 00:00:00 | 6640 | 11902 | 11528
2000-02-21 00:00:00 | 162 | 25558 | 25427
2000-02-22 00:00:00 | 5684 | 4500 | 4412 |  |  | x | x | x
2000-02-23 00:00:00 | 0 | 4500 | 4378 |  |  | x | x | x
2000-02-24 00:00:00 | 4662 | 4500 | 4298 |  |  | x | x | x
2000-02-25 00:00:00 | 5684 | 4500 | 4335 |  |  | x | x | x
2000-02-26 00:00:00 | 5684 | 4500 | 4519 |  |  | x | x | x | 0
2000-02-27 00:00:00 | 5684 | 4500 | 4301 |  |  | x | x | x
2000-02-28 00:00:00 | 5684 | 4500 | 4363 |  |  | x | x | x
2000-02-29 00:00:00 | 4949 | 5000 | 4363 |  |  | x | x | x
 |  |  | Total
 |  |  | Net SIT
* [NAME] faxed print screens to [NAME] on 3/10 to show the burn number changed after Enron true-ups.
**[NAME] faxed print screens to [NAME] on 3/6 to show the burn number changed after Enron true-ups.
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, November 16 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 221678d1363637225-need-help-conditional-formatting-a-cell-if-between-two-values-or-not-between-data-test-conform-rev1
Sheet: Sheet1

Data I already have.
Item | Inspection Method | Dimension/Specification |  | Specification / Limits |  | Test Date | Qty. Tested | Organization Measurement Results (Data) |  |  |  |  |  |  |  |  |  | Ok | Not Ok
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | Digital Calipers | w 45.00 | [NAME] | 45.1 | 44.9 |  |  | 45
2 | [NAME] | w 29.00 | [NAME] | 29.1 | 28.9
3 | Inside Micrometers | w 25.60 | [NAME] | 25.7 | 25.6
4 | [NAME] | 2.1 | [NAME] | 2.2 | 2.1
6 | Digital Calipers | 0.6 | [NAME] | 0.6 | 0.5
80
EXAMPLE:
What I would Like it to do
Item | Inspection Method | Dimension/Specification |  | Specification / Limits |  | Test Date | Qty. Tested | Organization Measurement Results (Data) |  |  |  |  |  |  |  |  |  | Ok | Not Ok
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | Digital Calipers | w 45.00 | [NAME] | 45.1 | 44.9 |  |  | 45.1 | 45 | 45.11 | 44 | 44.92
2 | [NAME] | w 29.00 | [NAME] | 29.1 | 28.9 |  |  | 29.1 | 29 | 29.11 | 28 | 28.92
3 | Inside Micrometers | w 25.60 | [NAME] | 25.7 | 25.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apply from I4::R(how ever many rows)
The formulas for the x's are
"=IF(D4="Basic","X",IF(MAX(I4:R4)>MAX(E4:F4),"",IF(MIN(I4:R4)<MIN(E4:F4),"","X")))" |  |  |  |  |  |  |  | = | x
"=IF(D5="Basic","",IF(MAX(I5:R5)>MAX(E5:F5),"X",IF(MIN(I5:R5)<MIN(E5:F5),"X","")))" |  |  |  |  |  |  |  | = | x
Spreadsheet: 85537d9b-b034-460a-b69f-d6f116355ea6
Sheet: Snowshoe Shuffle results 2012

Final Position | Bib Number | Last Name | First Name | Team | Total Elapsed Time
1 | 111 | Ness | [NAME] | M30-39 | 00:17:52.100000
2 | 126 | Womack | [NAME] | M20-29 | 00:21:32.900000
3 | 115 | Rantala | [NAME] | M50-59 | 00:24:54.800000
4 | 112 | Ness | [NAME] | F40-49 | 00:25:55.200000
5 | 129 | Vohs | [NAME] | M30-39 | 00:26:35.100000
6 | 130 | Singleton | Bryn | F30-39 | 00:28:40.700000
7 | 131 | Singleton | [NAME] | M40-49 | 00:28:45.200000
8 | 137 | Barton | Almine | F30-39 | 00:32:25.800000
9 | 114 | Rantala | [NAME] | F40-49 | 00:34:40.800000
10 | 119 | May | [NAME] | F40-49 | 00:36:05.500000
11 | 125 | Womack | [NAME] | M50-59 | 00:37:14.900000
12 | 127 | [NAME] | [NAME] | F40-49 | 00:40:57.900000
13 | 128 | Vohs | [NAME] | F30-39 | 00:41:02.200000
14 | 105 | Zanon | [NAME] | M50-59 | 00:41:46.500000
15 | 122 | MacDonald | Beverly | [NAME]+ | 00:42:10.900000
16 | 123 | [NAME] | [NAME] | M70+ | 00:45:42.900000
17 | 109 | [NAME] | [NAME] | M50-59 | 00:46:02.800000
18 | 108 | [NAME] | [NAME] | F50-59 | 00:46:24
19 | 110 | White | [NAME] | F40-49 | 00:46:27.300000
20 | 121 | May | [NAME] | M40-49 | 00:47:26.400000
21 | 120 | May | [NAME] | M19U | 00:47:32.400000
22 | 132 | Nicol | [NAME] | M50-59 | 0:49:32.100000 | -
23 | 133 | Nicol | [NAME] | F50-59 | 0:49:32 | -
24 | 135 | Puls | [NAME] | F30-39 | 00:49:32.700000
25 | 124 | Field | [NAME] | F60-69 | 00:49:37.600000
26 | 134 | [NAME] | Doug | M40-49 | 00:49:38
27 | 113 | Haga | [NAME] | F40-49 | 00:51:08.700000
28 | 107 | Huettle | [NAME] | M40-49 | 00:51:12.800000
29 | 117 | Duvall | Peggy | F50-59 | 00:51:17
DNS | 101 | [NAME] | [NAME] | F40-49 | - | -
DNS | 102 | Bright | [NAME] | F30-39 | - | -
DNS | 104 | Goldman | Eyal | M30-39 | - | -
DNS | 103 | Goldman | [NAME] | F20-29 | - | -
DNS | 136 | Gurney | [NAME] | F40-49 | - | -
DNS | 116 | Hosler | Caryl | F50-59 | - | -
DNS | 106 | May | [NAME] | F30-39 | - | -
DNS | 118 | Moorehead | Carol | F60-69 | - | -
Spreadsheet: 1f7ece2b-7d52-4bac-bc78-81466b5bda06
Sheet: Sheet1

Caseload Consideration | Number | Multiplier | Total
How many IEP students are on your roster? | 0 | 1 | 0
Students with up to 2 hours per day of direct instruction | 0 | 1 | 0
Students with between two and five hours per day of direct instruction | 0 | 1.25 | 0
Students with more than five hours per day of direct instruction | 0 | 1.5 | 0
Students with a 3-year reevaluation this year | 0 | 0.25 | 0
Students for whom you plan and supervise work experience | 0 | 1 | 0
Number of teachers with whom you co-teach | 0 | 1 | 0
Students who are dependent upon an adult for their physical needs | 0 | 1 | 0
Students on a Behavior Intervention Plan | 0 | 1 | 0
Number of associates with whom you collaborate | 0 | 1 | 0
Number of students you serve off-site? | 0 | 1 | 0
Caseload Total |  |  | 0
Spreadsheet: 690612d1597198302-need-help-programming-check-registger
Sheet: AF Checking

America First Checking |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Current Balance:
 |  |  |  |  |  | Cleared Balance:
 |  |  |  |  |  |  |  |  | EFT
 |  |  |  |  |  |  |  |  | DEP
 |  |  |  |  |  |  |  |  | TXFR
 |  |  |  |  |  |  |  |  | CARD
 |  |  |  |  |  |  |  |  | FEE
See instructions in the Help worksheet |  |  |  |  |  | Warn when balance is below: | 100
Date | Num | Payee / Description | Category | R | Withdrawal | Deposit | Balance
2019-01-01 00:00:00 |  |  |  | R |  | 3000
2019-04-01 00:00:00 |  | jj |  | R | 660
2020-08-05 00:00:00 |  | bill100 |  | R | 28.87
2020-08-06 00:00:00 |  | bill101 |  | R |  | 149.49
2020-08-06 00:00:00 |  | bill102 |  | R | 11.94
2020-08-06 00:00:00 |  | bill103 |  | R | 15.89
2020-08-06 00:00:00 |  | bill104 |  |  | 155.82
2020-08-07 00:00:00 |  | bill105 |  | R | 20.36
2020-08-07 00:00:00 |  | [NAME] |  | R | 28.6
2020-08-09 00:00:00 |  | bill107 |  | R | 52.58
2020-08-10 00:00:00 |  | bill108 |  |  |  | 500
2020-08-10 00:00:00 |  | bill109 |  |  | 10.99
2020-08-10 00:00:00 |  | bill110 | Groceries |  | 11.21
2020-08-10 00:00:00 |  | bill111 | Medicine/Drugs |  | 19.8
2020-08-11 00:00:00 |  | bill112 | MISC - Other |  | 58.25
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet10

 |  |  | Item | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00 |  | Test Due
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00 |  | Test in 30 days
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 1 | TBA
 |  |  | 1 | 2013-10-03 00:00:00 | 2014-10-03 00:00:00
 |  |  | 1 |  | 2013-02-24 00:00:00
 |  |  | 1 |  | 2014-10-03 00:00:00
 |  |  | 1 |  | 2014-10-03 00:00:00
 |  |  | 1 |  | 2014-10-03 00:00:00
 |  |  | 1 | TBA
 |  |  | 1 |  | 2014-10-03 00:00:00
 |  |  | 1 |  | 2013-08-17 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: 0106454e-a4fb-4227-acd0-a51126af46fe
Sheet: Pub Date

Month | Titles | Percentage
Jan | 45
Feb | 34
Mar | 30
Apr | 55
May | 49
June | 41
July | 44
Aug | 32
Sept | 49
Oct | 48
Nov | 66
Dec | 31
Spreadsheet: 03eb0dac-a351-44a5-9743-1d7c6afb251a
Sheet: FastFactsSplash

 |  |  |  |  | 3-Year Success
 |  |  |  |  | Fall 2009 Students |  |  |  |  |  |  |  | AY2012:  Race/Ethnicity
 |  |  |  |  | First-Time Students |  |  |  |  |  |  |  | White
 |  |  |  |  | Graduated (FRCC) |  |  |  |  |  |  |  | Minority
 |  |  |  |  | Transferred |  |  |  |  |  |  |  | International
 |  |  |  |  | Still Enrolled |  |  |  |  |  |  |  | Unknown/Not Reported
 |  |  |  |  | Stop-out/[NAME]-out
 |  |  |  |  | Graduated or Transferred
 |  |  |  |  | Graduated, Transferred, or Still Enrolled
 |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2011:  Retention
 |  |  |  |  | AY 2012 Awards:
 |  |  |  |  | Certificates
 |  |  |  |  | CTE Degrees
 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2012:  First Generation
 |  |  |  |  | Fall 2012:  Enrollment |  |  |  |  |  |  |  | One or Both Parents
 |  |  |  |  | Continuing Students
 |  |  |  |  |  |  |  |  |  |  |  |  | 1st Generation
 |  |  |  |  | New, First-Time Students |  |  |  |  |  |  |  | Unknown
Spreadsheet: 710382d1608910052-conditional-formatting-more-than-three-colours-blood_pressure_chart-etaf_modified
Sheet: Summary_Results

Date | Time | Systolic | Diastolic | Pulse | Category
Spreadsheet: 820410d1678097599-data-selection-using-drop-down-options-book1
Sheet: Summary

 | Start |  |  | End |  |  | Movement
 | 103 |  |  | 303
 | Qty | Value |  | Qty | Value |  | Qty | Value
No of sales orders
Status
Won
Lost
In Process
Spreadsheet: 885975d1735916930-conditional-formatting-formulas-pivot-tables-example
Sheet: Pivot Table

Average of TOTAL | SUPPLIER
REFERENCE | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Grand Total
Code 1 | 1638.702 | 1139.85 | 804.6 | 2467.44 | 1512.648
Code 2 | 3749.328 | 3313.8 | 4655.1 | 5628.200000000001 | 4336.607
Code 3 | 3397.68 | 2938 | 4217.2 | 5059.6 | 3903.12
Code 4 | 3006.596103896104 | 2858.59 | 1010.4 | 6668.64 | 3386.056525974026
Code 5 | 10556.22857142857 | 9385.98 | 13463.19 | 12362.25 | 11441.91214285714
Code 6 | 10668.84 | 8460.27 | 12874.68 | 14266.98 | 11567.6925
Code 7 | 10310.4 | 8750.4 | 12148.8 | 11217.6 | 10606.8
Code 8 | 7535.466666666667 | 5607.82 | 8155.02 | 7729.160000000001 | 7256.866666666667
Code 9 | 11639.50666666667 | 9646 | 14023.8 | 13407.94 | 12179.31166666667
Code 10 | 6771.093333333333 | 5032.059999999999 | 7113.76 | 11611.26 | 7632.043333333333
Grand Total | 6927.384134199134 | 5713.277 | 7846.654999999999 | 9041.907 | 7382.305783549784
Spreadsheet: 695999d1600527829-calculating-and-reporting-over-separate-months-example-forecasting-etaf
Sheet: Sheet1

 | Product no. | Cost | Margin | Duration (months) | Qty for sale
 | 1 | 100 | 20 | 5 | 20
 | 2 | 200 | 50 | 4 | 30
 | 3 | 50 | 10 | 12 | 100
 | 4 | 200 | 60 | 3 | 30
 | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Profit/loss | -100 | -50 | 50 | 100 | 25 | 160 | 180 | 300 | 400 | 450 | 400 | 360
 | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | P1 Profit/loss
 | [NAME]/loss
 | P3 Profit/loss
 | P4 Profit/loss
 | P5 Profit/loss
 | P6 Profit/loss
 | P7 Profit/loss
 | TOTAL
Spreadsheet: 731540d1620396456-extract-data-for-comparison-against-itself-tracker
Sheet: Data

Operator | Date | Site | Category | Page | Position | Coverage | Items | Notes/Changes since last week
Doe John | 2021-04-28 00:00:00 | JoeyT | New | 8 | 3 | 0.611111111111111 | Assorted | Change 3
Doe John | 2021-05-05 00:00:00 | JoeyT | New | 9 | 8 | 0.666666666666667 | Assorted | Change 5
Doe John | 2021-04-21 00:00:00 | JoeyT | Furniture | 5 | 4 | 0.722222222222223 | Table set
Doe John | 2021-04-28 00:00:00 | JoeyT | Furniture | 8 | 6 | 0.777777777777778 | Chair and Table Set | Shuffled
Doe John | 2021-05-05 00:00:00 | JoeyT | Books | 6 | 4 | 0.833333333333334 | Fiction | Layout changed
[NAME] | 2021-04-21 00:00:00 | JaneDoe | Books | 4 | 4 | 0.333333333333334 | Fiction | Change 2
[NAME] | 2021-04-28 00:00:00 | JaneDoe | Pens | 6 | 2 | 0.388888888888889 | Ink | Change 5
[NAME] | 2021-05-05 00:00:00 | JaneDoe | Electronics | 7 | 3 | 0.444444444444445 | Clocks | Change 4
[NAME] | 2021-04-28 00:00:00 | JaneDoe | Books | 21 | 8 | 0.5 | Non-fiction | Change 9
[NAME] | 2021-04-28 00:00:00 | DeerDoe | New | 4 | 4 | 0.555555555555556 | Assorted | Change 3
[NAME] | 2021-04-21 00:00:00 | Smith&Co | Furniture | 1 | 7 | 0.4444444444444444 | Chair, Chair and Table Set | Change 1
[NAME] | 2021-04-21 00:00:00 | Smithsons | Electronics | 22 | 5 | 0.1111111111111111 | Clocks | Change 4
[NAME] | 2021-04-28 00:00:00 | Smithsons | Furniture | 3 | 8 | 0.3333333333333333 | Chair | Change 3
[NAME] | 2021-05-05 00:00:00 | Smith&Co | Pets | 2 | 6 | 0.2222222222222222 | Dog beds | Change 1
[NAME] | 2021-05-05 00:00:00 | Smith&Co | Books | 7 | 9 | 0.32 | Non-fiction
Spreadsheet: 9a4357a4-fb79-4236-bdd7-91adf33af762
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
PENL | Test | PENL | Penicillium chrysogenum, IgE | Penicillium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PENL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PENL | Result | PENL | Penicillium, IgE | Penicillium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 39ecd008-1de2-4e29-9340-8085f0a08dce
Sheet: Crop Worksheet

CROP  WORKSHEET
 |  |  |  |  | TOTAL ACRES:
 |  |  |  |  | TOTAL COST:
CROP PRODUCTION/SALES |  | CROP EXPENSES |  |  | CROP PRODUCTION/SALES |  | CROP EXPENSES
CORN |  | CORN (costs/acre) |  |  | SOYBEANS |  | SOYBEANS (costs/acre)
acres | 0 | Chemicals |  |  | acres | 0 | Chemicals
yield (bu.) | 0 | Fertilizer |  |  | yield (bu.) | 0 | Fertilizer
production (bu.) |  | Trucking |  |  | production (bu.) |  | Trucking
price ($/bu) | 0 | Fuel |  |  | price ($/bu.) |  | Fuel
value produced |  | Insurance |  |  | value produced |  | Insurance
less corn for feed ($) |  | Interest |  |  | present inventory ($) |  | Interest
Production Value-feed |  | Rent |  |  | Sales |  | Rent | 0
present inventory ($) |  | Repairs |  |  | ending value |  | Repairs
sales** see notes |  | Seed |  |  |  |  | Seed
ending value |  | Storage/drying |  |  |  |  | Storage
 |  | Taxes |  |  |  |  | Taxes
 |  | Term Debt |  |  |  |  | Term Debt
 | 0 | [NAME]. | 0 |  |  |  | [NAME]. | 0
 |  | total/acre |  |  |  |  | total/acre
 | 0 | Total costs |  |  |  |  | Total costs
 |  | Breakeven/bu. |  |  |  |  | Beakeven/bu.
WHEAT |  | WHEAT (costs/acre) |  |  | ALFALFA |  | ALFALFA (costs/acre)
acres | 0 | Chemicals |  |  | acres | 0 | Chemicals | 0
yield (bu.) | 0 | Fertilizer |  |  | yield (tons) | 0 | Fertilizer | 0
production (bu.) |  | Trucking |  |  | production (tons/a.) |  | Trucking | 0
price ($/bu.) | 0 | Fuel |  |  | price ($[NAME].) | 0 | Fuel | 0
value produced |  | Insurance |  |  | value produced |  | Insurance | 0
present inventory ($) |  | Interest |  |  | present inventory ($) |  | Interest | 0
Sales |  | Rent |  |  | Sales |  | Rent | 0
ending value |  | Repairs |  |  | ending value |  | Repairs | 0
 |  | Seed |  |  |  |  | Seed | 0
 |  | Term Debt |  |  |  |  | Term Debt
 |  | [NAME]. | 0 |  |  |  | [NAME]. | 0
 |  | total/acre |  |  |  |  | total/acre
 |  | Total costs |  |  |  |  | Total costs
 |  | Breakeven/bu. |  |  |  |  | [NAME]
COMMENTS: | NOTE** If customer purchases all of his own complete feed, do not deduct feed corn from production.