tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1160__Model5
Sheet: Brownsville

INCOME STATEMENT - BROWNSVILLE
('000 $) |  | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00
Capacity Prices ($/kW-mo)
Capacity Revenue from Desk (Real $)
Capacity Revenue from Desk (Nominal $)
Expense
Fuel |  | 0 | 0 | 0
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
Insurance
SG&A
Utility Start Up Power
Property, Other Taxes |  | 554.3351570125001 | 618.2321916875001 | 657.1292263625
Mobilization |  | 0 | 0 | 0
Marketing Fee |  | 0 | 0 | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Salvage Value |  | 0 | 0
Without Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
With Salvage Value
Net Equity Cashflow | 0
Weighted Average Cost of Capital
Enterprise Value
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | 2000-01-31 00:00:00 | 2000-02-22 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00
Revenue (Real) | 119.526 |  | 1.735 | 43.09 | 112.139 | 423.552 | 5741.979 | 16804.032 | 18657.892 | 868.179 | 111.973 | 45.985 | 54.797 | 166.496 | 171.048 | 51.657 | 140.724 | 454.449 | 4261.608 | 11647.625 | 12371.476 | 801.756 | 148.793 | 55.578 | 67.413 | 171.817 | 170.608 | 56.484 | 155.028 | 435.719 | 3256.557 | 8590.812 | 8535.555 | 850.681 | 151.804 | 54.153 | 72.08
USD Libor |  |  | 0.0605681254028103 | 0.0605681254028103 | 0.0605681254028103 | 0.0614528938500749 | 0.062272420332016 | 0.0631418102820942 | 0.063791031540835 | 0.0644402529393635 | 0.0650281821846135 | 0.0655609806482027 | 0.0660765921541437 | 0.0665800294961341 | 0.0670369781793325 | 0.0674497060816499 | 0.0678640776304542 | 0.0681889253242094 | 0.0685246013111129 | 0.0688295340127438 | 0.0691069719563195 | 0.0693844099253584 | 0.0696329433757978 | 0.069856963974845 | 0.0700737581187561 | 0.07028720190671 | 0.0704860008481814 | 0.0706655611936435 | 0.0708378099668314 | 0.070965582403328 | 0.0710976139267086 | 0.0712170959618539 | 0.0713268914821796 | 0.0714366870064884 | 0.0715344306947476 | 0.0716232034710216 | 0.0717091126118303
Revenue (Nominal)
MW
Prices
 | Nominal Revenue | Capacity $
2000
2001
2002
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: ABC-CLIO

ABC-CLIO Databases
2004-2005
America History & Life | 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 | 2004-2005 Price | Price per search
TOTAL
[NAME]
Sessions | 60 | 38 | 111 | 242 | 355 | 212 | 52 | 202 | 269 | 270 | 119 | 54
Searches | 84 | 75 | 316 | 303 | 395 | 207 | 63 | 218 | 314 | 346 | 101 | 73
Historical Abstracts | 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
TOTAL
HA Database
Sessions | 25 | 6 | 106 | 155 | 269 | 83 | 24 | 71 | 142 | 144 | 68 | 12
Searches | 18 | 4 | 119 | 161 | 337 | 106 | 35 | 67 | 163 | 191 | 64 | 10
Spreadsheet: 66899d1267573663-conditional-unique-values-accounts
Sheet: Data

Budget |  |  |  |  |  |  |  |  |  |  |  |  | Key
Capital |  |  |  |  |  |  |  |  |  |  |  |  | 0
1480-15 | 4862.24 |  |  |  |  |  |  |  |  |  |  |  | 1
1480-xx | 4866.22 |  |  |  |  |  |  |  |  |  |  |  | 1
9101-01 | 11.22 |  |  |  |  |  |  |  |  |  |  |  | 2
 | 9739.679999999998 | subtotals |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Expenses |  |  |  |  |  |  |  |  |  |  |  |  | 2
2615-01 | 78000 |  |  |  |  |  |  |  |  |  |  |  | 3
1480-15 | 100 |  |  |  |  |  |  |  |  |  |  |  | 3
9101-01 | 98 |  |  |  |  |  |  |  |  |  |  |  | 3
 | 78198 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
Details of 1480-xx |  |  |  |  |  |  |  |  |  |  |  |  | 3
1480-01 | 4000 |  |  |  |  |  |  |  |  |  |  |  | 4
1480-02 | 800 |  |  |  |  |  |  |  |  |  |  |  | 5
1480-03 | 33 |  |  |  |  |  |  |  |  |  |  |  | 6
1480-03 | 33.22 |  |  |  |  |  |  |  |  |  |  |  | 6
 | 4866.22 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
Total | 87937.68000000001 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 21

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-21 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 |  |  |  |  |  | 2033 |  | 1687 |  | 67694 |  |  |  |  |  | 14 | 1 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2 | x
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7398 |  | 9009 |  | 67694 |  |  |  |  |  | 13 | 3 | x |  |  | 15
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 17 | 4 | x |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 5 | x |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3033 |  | 3674 |  | 67694 |  |  |  |  |  | 13 | 6 | x |  |  | 22
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 18 | 7 | x |  |  | 15
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 17 | 8 | x |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 9 | x |  |  | 20
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 22256 |  | 24866 |  | 67694 |  |  |  |  |  | 17 | 15 | x |  |  | 16
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 21 | 35 | x |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68915 | 0 |  |  |  |  | 17 | 39 | x |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2853 |  | 2954 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1917 |  | 1993 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.55
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 21014 |  | 20389 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3499 |  | 3604 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 5528 |  | 5414 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 7057 |  | 6479 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1367 |  | 1133 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 55 |  | 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: 825963d1681695665-copy-in-a-table-only-specific-row-from-another-table-having-an-amount-0-test
Sheet: TEST

a TEXT | b TEXT | c EUR | d% | e% | f EUR | g% |  | Invoice 1 |  |  |  | Invoice 2
1 | a | 1 | 0.01 | 0.07 |  | 1
2 | b | 4 | 0.02 | 0.08 |  | 1 |  | a TEXT | b TEXT | f EUR |  | a TEXT | b TEXT |  | f EUR
3 | c | 0 | 0.03 | 0.09 |  | 0 |  |  | a | 0.07
4 | d | 0 | 0.04 | 0 |  | 0 |  | 2 | b | 0.32
5 | e | 7 | 0.05 | 0.01 |  | 1 |  | 5 | e | 0.07
6 | f | 0 | 0.06 | 0.03 |  | 0
 |  |  |  |  |  |  |  |  | Total |  |  |  | Total
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: ASM Decor

Date Invoiced | Invoice Number | Invoice Value | Payment Due | Net Amount | CIS Amount | Paid Employee | Paid CIS | Overdue |  | Amounts Match? |  | Yes/No Options
2011-04-20 00:00:00 | 0009 | 203.05 |  |  |  |  |  |  |  |  |  | Yes
2011-04-21 00:00:00 | 0010 | 172.9 |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 132010d1323438849-nested-if-or-and-matched-indexed-statements-final-yez-sample
Sheet: Names List

All the vital info and tick list
 | Booking # | Tour Code | Names | Room type | Room # | Age | DOB | Nationality | Passport # | Phone # | Dietary | Medical | Next of Kin | Meeting where | Notes | [NAME]
1 |  | YEZ | Driver | Single |  | N/A
2 |  | YEZ | Miss s | Twin | 1 | N/A
3 |  | YEZ | mr s | Twin | 1
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 30047d1225330807-contains-symbol-test
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | week | 1
Spreadsheet: 437452d1451350237-possible-scenarios-possible
Sheet: Raw Data

Employee | Widgets | Hours | Widgets per hour
Terrence | 125 | 40
[NAME] | 105 | 38
[NAME] | 225 | 40
[NAME] | 125 | 41
Zack | 221 | 40
[NAME] | 98 | 39
Dhanshree | 110 | 39
[NAME] | 108 | 40
Spreadsheet: 584441d1533183362-take-x-until-a-certain-value-is-met-then-take-100-billing-calculations-formula-method
Sheet: Billing Period Totals

Billing Period | Cumulative Total Collected |  |  |  | Jan-18 | Running Total | Amount to keep | Feb-18 | Running Total | % to keep | Mar-18 | Running Total | % to keep
2018-01-01 00:00:00
2018-02-01 00:00:00
2018-03-01 00:00:00
2018-04-01 00:00:00
2018-05-01 00:00:00
2018-06-01 00:00:00
2018-07-01 00:00:00
2018-08-01 00:00:00
2018-09-01 00:00:00
2018-10-01 00:00:00
2018-11-01 00:00:00
2018-12-01 00:00:00
2019-01-01 00:00:00
2019-02-01 00:00:00
2019-03-01 00:00:00
2019-04-01 00:00:00
2019-05-01 00:00:00
2019-06-01 00:00:00
2019-07-01 00:00:00
2019-08-01 00:00:00
2019-09-01 00:00:00
2019-10-01 00:00:00
2019-11-01 00:00:00
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: 12cf93eb-244e-445e-b4f9-79e0d3a6d7b2
Sheet: Sheet1

MEN Run division--Overall Winners
1st [NAME] |  | M28 | 18'12
2nd Tyler Wade |  | M24 | 18'23
3rd  [NAME] |  | M49 | 18'40
MENS Overall Walker
[NAME] |  | M46 | 30'12
9 & Under Results MEN
1. [NAME] |  | M9 | 30'16
2. [NAME] |  | M9 | 32'00
3. [NAME] |  | M9 | 41'25
10--14 Results MEN
1. [NAME] |  | [NAME] | 20'20
2. [NAME] |  | [NAME] | 21'36
3. [NAME] |  | [NAME] | 23'43
4. [NAME] |  | M11 | 24'17
5. [NAME] |  | [NAME] | 24'19
6. [NAME] |  | M12 | 26'09
7. [NAME] |  | [NAME] | 26'21
8. [NAME] |  | M11 | 27'16
9. [NAME] Little |  | M14 | 28'10
10. Dillon Scott |  | M12 | 31'45
11. [NAME] |  | M11 | 31'46
12. Hayden Barksdale |  | M12 | 37'37
15--19 Results MEN
1. [NAME] |  | M15 | 28'47
2. [NAME] |  | M15 | 28'56
3. [NAME] |  | M18 | 29'51
4. [NAME] |  | [NAME] | 30'02
20--24 Results MEN
1. [NAME] |  | M21 | 20'34
2. [NAME] |  | M24 | 21'45
3. [NAME] |  | M23 | 22'11
4. [NAME] |  | M20 | 22'42
5. [NAME] |  | M20 | 22'45
6. [NAME] |  | M21 | 23'17
7. [NAME] |  | M20 | 24'30
8. [NAME] |  | M23 | 24'42
9. [NAME] |  | M20 | 24'55
10. [NAME] |  | M24 | 25'06
11. [NAME] |  | M24 | 25'42
12. [NAME] |  | M20 | 26'10
13. [NAME] |  | M21 | 26'16
14. [NAME] |  | M22 | 26'25
15. [NAME] |  | M22 | 26'26
16. [NAME] |  | M23 | 27'10
17. Justin Pritchard |  | M22 | 27'31
18. [NAME] |  | M24 | 28'43
19. [NAME] |  | M23 | 32'33
20. [NAME] |  | M20 | 32'40
21. [NAME] |  | M20 | 33'43
22. [NAME] |  | M21 | 36'19
23. [NAME] |  | M22 | 36'27
24. [NAME] |  | M22 | 39'31
25. [NAME] |  | M23 | 40'00
26. [NAME] |  | M22 | 40'02
27. [NAME] |  | M23 | 40'06
28. [NAME] |  | M20 | 41'01
29. [NAME] |  | M21 | 41'02
30. Murphy Buggs |  | M22 | 41'03
31. Jared Culliver |  | M22 | 42'03
32. Dakota Bibbs |  | M20 | 43'15
33. [NAME] |  | M21 | 45'05
34. Vicktor Barnette |  | M20 | 51'24
25--29 Results MEN
1. Micah Duchesne |  | M28 | 21'44
2. [NAME] |  | M27 | 25'01
3. [NAME] |  | M26 | 30'45
30--34 Results MEN
1. [NAME] |  | M33 | 19'45
2. [NAME] |  | M33 | 25'59
3. [NAME] |  | M31 | 38'01
35--39 Results MEN
1. [NAME] |  | M37 | 26'27
2. [NAME] |  | M38 | 28'08
3. [NAME] |  | M38 | 32'02
40--44 Results MEN
1. [NAME] |  | M44 | 23'06
2. [NAME] |  | M40 | 23'21
3. [NAME] |  | M44 | 24'26
4. [NAME] |  | M43 | 25'41
5. [NAME] |  | M44 | 27'00
6. [NAME] |  | M43 | 27'23
7. [NAME] |  | M45 | 28'31
8. [NAME] |  | M41 | 41'31
45--49 Results MEN
1. [NAME] |  | M46 | 25'44
2. [NAME] |  | M49 | 26'34
3. [NAME] |  | M47 | 27'06
4. [NAME] |  | M46 | 30'12
5. Lance Barksdale |  | M45 | 37'38
6. [NAME] |  | M45 | 49'10
50--54 Results MEN
1. [NAME] |  | M53 | 24'45
2. [NAME] |  | M51 | 32'54
3. [NAME] |  | M50 | 36'37
55--59 Results MEN
1. [NAME] |  | M55 | 25'16
2. [NAME] |  | M56 | 27'57
60--64 Results MEN
1. [NAME] |  | M62 | 22'57
2. [NAME] |  | M62 | 50'44
65 and over Results MEN
1. [NAME] |  | M66 | 23'36
Spreadsheet: 178269d1346746723-week-commencing-wc-friday
Sheet: Sheet1

Dates | Fridays
2012-08-09 00:00:00
Spreadsheet: 546698d1510160073-how-do-i-make-excel-not-count-squared-or-superscripted-numbers-excel-sample-3-
Sheet: Group Sampras

 |  |  |  | W | L | SF | SA | GF | GA | Pts |  |  | 1 | [NAME] | 6 | 4 | 7 7
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 3 | 6 | 6 5
 |  | 2 | Dominic Thiem
 |  | 3 | [NAME] |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  | 4 | [NAME] |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
Spreadsheet: 15c43e74-8951-4f44-a44e-9bf8601986ef
Sheet: Lists

VACCINE |  |  | FUNDING |  | PAYOR |  |  | AGENCY NAME |  |  | POPULATION |  |  | INSURER NAME |  | CLAIM PROCESSING? |  | VACCINES OFFERED |  | NON-STUDENT?
DT | DT |  | PRIVATE |  | CHP+ |  |  | [NAME] |  |  | [NAME] only |  |  | Aetna |  | YES - contract with payer |  | Flu only |  | Y
DTAP | DTAP |  | PUBLIC/FED |  | CO ACCESS - ADULT |  |  | Bent |  |  | Middle only |  |  | Alliance |  | NO - no contract w/ payer |  | Catch-up only |  | N
FLU | FLU |  |  |  | MEDICAID ADULT |  |  | Boulder |  |  | High School only |  |  | Anthem/BCBS - Colo |  |  |  | Flu & Catch-up
HEP A | HEP A |  |  |  | MEDICARE |  |  | Chaffee |  |  | K-12 |  |  | Anthem/BCBS - Other State
HEP AB | HEP AB |  |  |  | PRIVATE INSURANCE - ADULT |  |  | Costilla |  |  | Elementary & Middle |  |  | Assurant
HEP B | HEP B |  |  |  | PRIVATE INSURANCE - CHILD |  |  | Delta |  |  | Middle & High School |  |  | [NAME]
HIB | HIB |  |  |  | UNDERINSURED ADULT |  |  | Denver |  |  |  |  |  | Cigna
HPV | HPV |  |  |  | UNINSURED ADULT |  |  | Dolores |  |  |  |  |  | CNIC
KINRIX | DTAPIPV |  |  |  | VFC - MEDICAID |  |  | [NAME] |  |  |  |  |  | Cofinity
MENINGOCOCCAL | MCV4 |  |  |  | VFC - MEDICAID RESTRICTED |  |  | Grand |  |  |  |  |  | Golden Rule
MMR | MMR |  |  |  | VFC - NO INSURANCE |  |  | [NAME] |  |  |  |  |  | Humana
PEDIARIX | DTAPHBIP |  |  |  | VFC - AM INDIAN/AK NATIVE |  |  | [NAME] |  |  |  |  |  | Kaiser
PENTACEL | DTAPIPHI |  |  |  | VFC - UNDERINSURED |  |  | Larimer |  |  |  |  |  | Pacificare
PNUEMO | PNUEMO |  |  |  | INCOMPLETE CONSENT FORM |  |  | Mesa |  |  |  |  |  | Rocky Mountain
POLIO | EIPV |  |  |  | OTHER (LIST IN NEXT CELL) |  |  | Montezuma |  |  |  |  |  | Tricare
PREVNAR | PNU 13 |  |  |  |  |  |  | Montrose |  |  |  |  |  | UMR
[NAME] | ROTA |  |  |  |  |  |  | Northeast |  |  |  |  |  | United Health Care
TDAP | TDAP |  |  |  |  |  |  | Park |  |  |  |  |  | Other (List in next cell)
VARICELLA | VAR |  |  |  |  |  |  | Pitkin
 |  |  |  |  |  |  |  | Prowers
 |  |  |  |  |  |  |  | Pueblo
 |  |  |  |  |  |  |  | Rio Grande
 |  |  |  |  |  |  |  | San Juan Basin
 |  |  |  |  |  |  |  | San Juan County
 |  |  |  |  |  |  |  | Saquache
 |  |  |  |  |  |  |  | Summit
 |  |  |  |  |  |  |  | Teller
 |  |  |  |  |  |  |  | Tri-County
 |  |  |  |  |  |  |  | Weld
Spreadsheet: 275810d1383653902-vlookup-based-on-multiple-criteria-problem-exampledoc_alkey
Sheet: Sheet1

Example
Name | Month | Wages
[NAME] | January | 2100
[NAME] | February | 2300
[NAME] | March | 2000
[NAME] | April | 2033
[NAME] | May | 1983
[NAME] | June | 1933
[NAME] | July | 1833
[NAME] | August | 1929
[NAME] | September | 1839
[NAME] | October | 1898
[NAME] | November | 1987
[NAME] | December | 1898
[NAME] | January | 1794.57692307692
[NAME] | February | 1770.15384615385
[NAME] | March | 1745.73076923077
[NAME] | April | 1721.30769230769
[NAME] | May | 1696.88461538461
[NAME] | June | 1672.46153846154
[NAME] | July | 1648.03846153846
[NAME] | August | 1623.61538461538
[NAME] | September | 1599.19230769231
[NAME] | October | 1574.76923076923
[NAME] | November | 1550.34615384615
[NAME] | December | 1525.92307692308
[NAME] | January | 1477.07692307692
[NAME] | February | 1452.65384615385
[NAME] | March | 1428.23076923077
[NAME] | April | 1403.80769230769
[NAME] | May | 1379.38461538461
[NAME] | June | 1354.96153846154
[NAME] | July | 1330.53846153846
[NAME] | August | 1306.11538461538
[NAME] | September | 1281.69230769231
[NAME] | October | 1257.26923076923
[NAME] | November | 1232.84615384615
[NAME] | December | 1208.42307692308
Name | Month
[NAME] | February
Wages
Spreadsheet: 269706d1381251781-running-percent-help-next-call-that-counts
Sheet: Sheet1

Case | Call Type | Take Over % So Far |  |  |  | Consult & Take Over | T1 calls and you take over
123123123 | Consult & Take Over | 100 |  |  |  | Consult Only | T1 calls and keeps the call
223223223 | Out Bound | 100 |  |  |  | Out Bound | You Call a Customer
323323323 | InBound | 100 |  |  |  | InBound | Incoming Call where no "take over" happens
423423423 | Consult Only | 50 | As this is the next call that counts as part of the takeover percent the take over percent so far changes to represent 1 take over out of the two calls that count.
Spreadsheet: 270072d1381360118-summary-tab-in-workbook-budgets-2014-amync
Sheet: 3rd Grade

Third Grade |  | Third Grade |  | Third Grade
Steps to Health |  | Steps to Health |  | Steps to Health
Budget for Alexander County |  | Budget for Alleghany County |  | Budget for Bladen County
2013-2014 |  | 2013-2014 |  | 2013-2014
Item Description | Total Dollars Allowed  Per Item | Item Description | Total Dollars Allowed Per Item | Item Description | Total Dollars Allowed Per Item
Food for 8 Taste Tests/Food Demonstrations |  | Food for 8 Taste Tests/Food Demonstrations |  | Food for 8 Taste Tests/Food Demonstrations
Food for 8 taste tests or food demos |  | Food for 8 taste tests or food demos |  | Food for 8 taste tests or food demos
Supplies for Sessions |  | Supplies for Sessions |  | Supplies for Sessions
Forks, spoons, plates, napkins, cups, hand sanitzer, plastic wrap, [NAME], paper towels |  | Forks, spoons, plates, napkins, cups, hand sanitzer, plastic wrap, [NAME], paper towels |  | Forks, spoons, plates, napkins, cups, hand sanitzer, plastic wrap, [NAME], paper towels
Reams of white and color paper, pencils, and wide masking tape |  | Reams of white and color paper, pencils, and wide masking tape |  | Reams of white and color paper, pencils, and wide masking tape
Photocopying of Surveys, Attendance, & Feedback Forms for Agent's Record |  | Photocopying of Surveys, Attendance, & Feedback Forms for Agent's Record |  | Photocopying of Surveys, Attendance, & Feedback Forms for Agent's Record
Pre & Post Survey, Parent Feedback Forms, [NAME], Teacher Feedback, Receipts, Reimbursement Forms, etc. |  | Pre & Post Survey, Parent Feedback Forms, [NAME], Teacher Feedback, Receipts, Reimbursement Forms, etc. |  | Pre & Post Survey, Parent Feedback Forms, [NAME], Teacher Feedback, Receipts, Reimbursement Forms, etc.
Postage |  | Postage |  | Postage
Covers the cost of mailing receipts and completed forms |  | Covers the cost of mailing receipts and completed forms |  | Covers the cost of mailing receipts and completed forms
Travel |  | Travel |  | Travel
Driving to the school (setting up program start dates and teaching the program), grocery store, and post office.   [NAME] is .565/per mile if using pesonal vehicle or a predetermined rate if using a state vehicle |  | Driving to the school (setting up program start dates and teaching the program), grocery store, and post office.   [NAME] is .565/per mile if using pesonal vehicle or a predetermined rate if using a state vehicle |  | Driving to the school (setting up program start dates and teaching the program), grocery store, and post office.   [NAME] is .565/per mile if using pesonal vehicle or a predetermined rate if using a state vehicle
Spreadsheet: 877586d1724399823-function-like-if-function-needed
Sheet: Sheet1

 | Grade 1 | [NAME] | [NAME] | [NAME]
 | 3 | 1 | 1 | 2
 | 3 | 3 | 3 | 3
 | 1 | 4 | 2 | 3
 | 1 | 1 | 4 | 3
 | 1 | 3 | 3 | 2
 | 1 | 4 | 3 | 2
 | 4 | 3 | 3 | 4
 | 4 | 4 | 1 | 3
 | 2 | 3 | 1 | 1
 | 1 | 1 | 4 | 4
 | 1 | 3 | 1 | 4
 | 1 | 1 | 3 | 1
 | 1 | 1 | 1 | 3
 | 1 | 3 | 3 | 2
 | 1 | 4 | 4 | 2
 | 1 | 3 | 4 | 4
 | 3 | 1 | 1 | 4
 | 1 | 1 | 1 | 2
Spreadsheet: 857095d1706169067-need-help-automatic-color-in-achievement-results-color-100-green-100-red-rumus-hijau-merah-aligw
Sheet: Sheet1

 | Achivment MTD Perhari 17 Des
 | Desember 2023
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 1.2 | 0.5 | 1.8 | 0.6 | 0.5
 |  |  |  |  | 10
Spreadsheet: 782456d1654066851-how-to-count-without-splitting-data-from-cell-excel
Sheet: Sheet1

A035F-BLUE |  |  |  | A035F | A035FZ | A135F
A035F-BLACK
A035F-BLACK
A035F-BLACK
A035F-BLACK |  |  |  |  |  |  |  | Want to get how many model available in Column E, F and G, based on column A
A035F-BLACK |  |  |  |  |  |  |  | I can do it by using two formula but I want to get it in single forumula
A035F-BLACK
A035FZ-BLACK
A035FZ-BLACK
A035FZ-BLACK
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-BLUE
A135F-Peach
A135F-Peach
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE
A035FZ-BLUE