tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885669d1735479600-column-of-referring-row-numbers-of-found-celvalue-question_rownumbers
Sheet: Blad1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Named ranges | Row number |  | Named ranges | Row number |  | Named ranges | Row number |  | ALS(H9=-1;-1;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kop_rij_tbl1 |  |  | Kop_rij_tbl2 |  |  | Kop_rij_tbl3 |  |  | ALS(H9<max_rij_tbl_1;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  | Formule kolom |  |  |  | Wanted result |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_1;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="TOTAAL")/(Blad2!$E$7:$E$32="TOTAAL")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | MAX_rij_tbl1 |  |  | MAX_rij_tbl2 |  |  | MAX_rij_tbl3 |  |  | ALS(H9=Totaal_rij_tbl_1;"/1";
 |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | Totaal_rij_tbl1 |  |  | Totaal_rij_tbl2 |  |  | Totaal_rij_tbl3 |  |  | ALS(H9="/1";Kop_rij_tbl_2;
 |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_2;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9=Totaal_rij_tbl_2;"/2";
 |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9="/2";Kop_rij_tbl_2;
 |  |  |  |  |  |  |  |  |  |  | /1 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9<Totaal_rij_tbl_2;AGGREGAAT(15;3;(Blad2!$E$7:$E$32="HCAT")/(Blad2!$E$7:$E$32="HCAT")*(RIJ(Blad2!$E$7:$E$32));RIJEN($G$10:G10));
 |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALS(H9=Totaal_rij_tbl_2;"/2"
 |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | ))))))))))
 |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  | /2
 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
 |  |  |  |  |  |  |  |  |  |  | -1
Spreadsheet: 058f8cf7-3056-4be0-b32a-1529f4e02243
Sheet: Sheet1

Service | Mb/s | Media Type | Non-recurring/ | Installation | Recurring | Annual Price
 |  |  | Edge device
400 [NAME] | 400 | Copper Ethernet | 1799 | 525 | 666.5 | 7998
400Mbps ZX | 400 | Copper Ethernet | 3159 | 525 | 666.5 | 7998
1000 [NAME] | 1000 | MM or SM Fiber Ethernet | 1799 | 525 | 1144.61 | 13735.32
1000 [NAME] | 1000 | MM or SM Fiber Ethernet | 3159 | 525 | 1144.61 | 13735.32
Secondary 400 [NAME] circuit, shared edge device | 400 | Copper Ethernet | 0 | 0 | 363.42 | 4361.04
5 -year term pricing.
Pricing per each individual network location.
Services subject to availability.
Exempt from Federal, State, or Local Telecommunications fees, taxes or surcharges.
Pittock port charges may apply for fiber or copper interfaces.
Prices effective 07-01-13 through 06-30-14.
Spreadsheet: 0a20438b-f89e-4369-9ad8-2afbc541f6ba
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4318 | 15355 | [NAME] | [NAME] | USA | 0 |  |  |  |  |  | 1 | 02:31:05
4318 | 10421 | Greg | Welch | AUS | 0 |  |  |  |  |  | 2 | 02:31:06
4318 | 15394 | Mark | [NAME] | USA | 0 |  |  |  |  |  | 3 | 02:34:21
Spreadsheet: 785483d1656439264-excel-skills-for-business-advanced-week-2-problem-wssa
Sheet: Table_Data

 | Section 1 - Tables
 |  |  |  |  | Celsius = (Fahrenheit - 32) * (5/9)
 | Table Name: | City_Subset
 | Location | High_F | Low_F |  | High (C) | Low (C)
 | Atlanta, Georgia | 72 | 53
 | Austin, Texas | 80 | 59 |  | 26.66666666666667 | 15
 | Baltimore, Maryland | 65 | 45 |  | 18.33333333333334 | 7.222222222222222
 | Birmingham, Alabama | 74 | 53 |  | 23.33333333333334 | 11.66666666666667
 | Boston, Massachusetts | 59 | 44 |  | 15 | 6.666666666666667
 | Buffalo, New York | 56 | 40 |  | 13.33333333333333 | 4.444444444444445
 | Charlotte, North Carolina | 71 | 49 |  | 21.66666666666667 | 9.444444444444445
 | Chicago, Illinois | 59 | 41 |  | 15 | 5
 | Cincinnati, Ohio | 65 | 43 |  | 18.33333333333334 | 6.111111111111112
 | Cleveland, Ohio | 60 | 43 |  | 15.55555555555556 | 6.111111111111112
 | Columbus, Ohio | 63 | 44 |  | 17.22222222222222 | 6.666666666666667
 | Dallas, Texas | 77 | 57 |  | 25 | 13.88888888888889
 | Denver, Colorado | 64 | 36 |  | 17.77777777777778 | 2.222222222222222
 | Detroit, Michigan | 59 | 42 |  | 15 | 5.555555555555555
 | Count of number of cities |  |  |  | Check_Sum |  | Question 3
 | Average High (F)
 | Minimum Low (F)
 | Product of the values above |  | Question 2
 | End of Section
Spreadsheet: 858469d1707149241-create-billing-tool-sample-file
Sheet: Sheet1

[NAME] | 994
DC | 1200
Electric | 400
Water | 150
Trash | 40
Tot
MyHA
Each Week
PC | 607.57
Rem
Spreadsheet: 864570d1711693900-weeknum-and-countif-book6-dj
Sheet: Sheet1

DATE | [WEEKNUM] but generally I don't want this |  | WEEK | COUNT
2024-03-08 00:00:00 |  |  | 11
2024-03-08 00:00:00
2024-03-14 00:00:00
2024-03-15 00:00:00
2024-03-15 00:00:00
2024-03-19 00:00:00
2024-03-19 00:00:00
2024-03-25 00:00:00
2024-03-25 00:00:00
2024-03-25 00:00:00
Spreadsheet: 96680d1296013735-elec-gas-and-water-cumulative-totals-my-cumulative-total-elec-gas-and-water
Sheet: ELEC

ELEC KWH PRICE RANGES | FROM | TO | PRICE | formula's | UNITS PER PRICE RANGE | formula's
RANGE1 | 0 | 250 | 0.15 | 250 | 250
RANGE2 | 251 | 300 | 0.14 | 49 | 49 | 79
RANGE3 | 301 | 400 | 0.13 | 99 | 30 | 30
RANGE4 | 401 | > | 0.12 |  | 0 | 0
ELEC KWH'S | PRICE RANGE1 TOTAL | PRICE RANGE2 TOTAL | PRICE RANGE3 TOTAL | PRICE RANGE4 TOTAL | TOTAL
329 | 37.5 | 6.86 | 3.9 | 0 | 48.26
Spreadsheet: 600185d1543511057-count-if-matches-2-criteria-offset-count-if
Sheet: Sheet1

3980.83 | 0 | 0 | 41
2180.96 | 0 | 0 | 41 |  | Countif(A2:A8>0*D=41
6634.69 | 0 | 0 | 41
18442.44 | 0 | 0 | 42
5058.45 | 0 | 0 | 42
17329 | 0 | 0 | 43
12906 | 2800 | 1 | 43
Spreadsheet: 732643d1621092806-price-menu-dependent-drop-downs-with-lookup-function-based-on-multiple-selections-price-menu-xlookup
Sheet: Lists

Service_List
Spreadsheet: 840426d1692720636-conutifs-row-and-column-data-1-
Sheet: summary

 | DEBBIE
 | HEO Learning Needs Analysis
 |  |  |  |  |  | COUNT & % (count/heo)
 | Learning Area | Courses | Reference | Media | Access From | 1 | 2 | 3 | 4
 |  | NAME
 | Induction &  Onboarding | DWP Induction | N/A | Various | Intranet
 |  | ODP Induction Learning (2020) | N/A | E Learning | Civil Service Learning
 |  | Diversity and inclusion - I Can Be Me campaign | N/A | Open Learning | Intranet
 |  | [NAME] | N/A | Open Learning | Intranet
Spreadsheet: 490129d1479700370-i-think-countif-is-my-solution-but-im-having-trouble-solving-test
Sheet: Sheet1

 | NA | NA | NA | EMEA | EMEA | EMEA
PROJECT | US | CA- | CA- | UK | FR | DE | TOTAL # 0F
 |  | EN | FR |  |  |  | LANGUAGES
PROJECT | X | X | X | X | X | X
1
PROJECT |  |  | X |  | X
2
PROJECT | X |  | X |  | X
3
PROJECT |  |  |  |  | X | X
4
Spreadsheet: 707601d1607359334-finding-the-added-and-deleted-codes-out-of-the-two-sets-of-codes-entered-count-gk
Sheet: Input

coder | deletedcode | Addcode |  |  |  | Code | All
S123 | E712,E888 | H11 |  |  |  | E712
H888 | Y123,908 | E888 |  |  |  | E888
D134 | 8182,345 | U908 |  |  |  | H11
D134 | U908,U908 | 908,911,912 |  |  |  | Y123
H888 | 908,U908 | E888 |  |  |  | 908
 |  |  |  |  |  | 8182
 |  |  |  |  |  | 345
 |  |  |  |  |  | U908
 |  |  |  |  |  | 911
 |  |  |  |  |  | 912
Spreadsheet: 488891d1478884080-subtract-only-the-matched-criteria-from-row-amount-prepayment-schedule_11112016
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-02-28 00:00:00 | 2018-02-28 00:00:00 | 2018-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Annual ASM | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Add-On ASM | [NAME] | Post Go-Live Services | Leasing | Add-On ASM | [NAME] | Post Go-Live Services | Leasing
 | Category | Invoice Date | Invoice Amount | Amount Paid Date | Paid Value | Prepaid Months | Revenue Per Month | Prepaid Value | Begin Month | Begin Date | End Date
 | Leasing | 2017-01-31 00:00:00 | 150000 | 2017-01-16 00:00:00 | 150000 | 12
 | Leasing | 2017-02-28 00:00:00 | 60000 | 2017-02-16 00:00:00 | 60000 | 12
Spreadsheet: 708412d1607798059-formula-for-combination-of-multiple-if-conditions-testbook
Sheet: Sheet1

Productivity (A ranging 0 - 35) | Quality (B ranging 0 - 35) | Others (C Ranging 0 - 8) | Total (A+B+C) | Score |  | Conditions:
32 | 34 | 8 |  | 7 |  | A range is 0 - 35, B range is 0 - 35 and C range is 0-8
30 | 35 | 7 |  | 6 |  | D = A + B + C
30 | 31 | 1 |  | 5 |  | find E
25 | 23 | 5 |  | 4 |  | If D >= 74, E = 7
22 | 21 | 1 |  | 3 |  | if D >= 68, and <74, E = 6
19 | 23 | 5 |  | 3 |  | if D>=60 and <68, E = 5
23 | 19 | 5 |  | 3 |  | if D >=49 and <60, E=4
16 | 25 | 2 |  | 2 |  | if D >=44 and <49 or A <20 or B < 20, E=3
14 | 27 | 4 |  | 2 |  | if D >=30 and <44 or A <15 or B < 15, E=2
12 | 20 | 8 |  | 1 |  | if D < 30 or A <15 or B < 15, E=1
15 | 15 | 0 |  | 2
Spreadsheet: 4ebe2465-3f66-4ac3-92e8-04d9a51fd710
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 10/15/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
June | 7.41 | 6.7 | 7.13 | 6.54 | 9.18 | 8.31 | 9.26 | 7.78
July | 7.1 | 7.93 | 6.77 | 7.79 | 10.2 | 8.6 | 8.45 | 8.53
August | 7.59 | 8.04 | 7.27 | 7.92 | 10.2 | 7.7 | 8.28 | 8.27
September | 7.54 | 8.49 | 7 | 8.51 | 10.8 | 7.84 | 8.09 | 8.52
October | 7.27 |  | 6.53 |  | 9.6 |  | 8.19
November | 7.3 |  | 6.44 |  | 10.3 |  | 8.43
December | 7.2 |  | 6.41 |  | 10.3 |  | 8.25
January | 7.05 |  | 6.57 |  | 8.84 |  | 8.09
February | 7.1 |  | 6.68 |  | 8.98 |  | 8.01
March | 7.2 |  | 6.7 |  | 8.39 |  | 8.04
April | 7.11 |  | 6.47 |  | 9.22 |  | 7.96
May | 6.67 |  | 6.42 |  | 8.95 |  | 7.93
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 10/15/2012
Spreadsheet: 598901d1542784510-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-20112018-1-ans1
Sheet: Rent Roll

 |  |  |  | Inflation | Year
 |  |  | CPI regulation | CPI |  | 0.01 | 0.02 | 0.03 | 0.02 | 0.05
 |  | Tenant 1 | 1 | 1
 |  | [NAME] | 2 | 0.5
 |  | Tenant 3 | 3 | 0.75
 |  |  |  |  | NOTE: Changes are done in formula in G3:K5 and  G1:K1
 |  | Correct answer annually
 |  | Tenant 1
 |  | Accummulated
 |  | [NAME]
 |  | Accummulated | 1 |  |  |  | 1.0405785075
 |  | Tenant 3
 |  | Accummulated | 1 |  |  | 1.04562128125 | 1.04562128125
 |  | Comments: Some tenants only get the CPI indexed 50 % or 75% or whatever below 100% depending on lease contract. I would like to capture this on a quarterly basis, I.e how you did it on the tab "income calc", but reflecting the CPI (between 0 and 100%)
Spreadsheet: 525826d1498938717-conditional-formatting-future-dates-on-cell-tobe-formatted-hr-template
Sheet: 1

 | Mandatory Training |  |  | Induction |  | Customer Complaints |  | Data Protection |  | Anti-Money Laundering |  | Bribery |  | Health & Safety
 | 1 | Director |  | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due | Date Completed | [NAME] Due
 |  |  |  | 2015-10-15 00:00:00 | 2016-04-15 00:00:00
 |  |  |  | 2016-10-15 00:00:00 | 2017-04-15 00:00:00
 |  |  |  | 2017-04-15 00:00:00 | 2017-05-12 00:00:00
 |  |  |  | 2017-06-01 00:00:00 | 2017-07-12 00:00:00
Spreadsheet: 730421d1619696956-highlight-date-range-on-calendar-test-2-copy
Sheet: Hire

 |  |  |  |  |  |  |  |  | HIRE RECORD
Hire Start Date | M/C No. | Customer | Site | Machine Hours | Hire End Date | Machine Hours | Hire Period Weeks | Total Hire Hours | Comments
2020-02-17 00:00:00 | 39 | S-LL | LL |  | 2020-04-18 00:00:00
2020-05-08 00:00:00 | 39 | S-LL | LL |  | 2020-05-28 00:00:00
2020-05-01 00:00:00 | 39 | L - Lanark | Lanark
2020-06-10 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-06-17 00:00:00
2020-07-06 00:00:00 | 39 | L - Lanark | Lanark |  | 2020-07-10 00:00:00
2020-07-13 00:00:00 | 39 | S - Bredbury | [NAME] |  | 2020-08-07 00:00:00
2020-09-21 00:00:00 | 39 | HH | Bury |  | 2020-09-23 00:00:00
2020-09-30 00:00:00 | 39 | CS | WS |  | 2020-11-17 00:00:00
2020-10-22 00:00:00 | 33 | LE | London |  | 2020-11-17 00:00:00
2020-11-17 00:00:00 | 33 | CS | WS
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-11-24 00:00:00
2020-11-24 00:00:00 | 39 | RL | Preston |  | 2020-12-04 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME] |  | 2020-11-25 00:00:00
2020-11-25 00:00:00 | 33 | DS | [NAME]
2020-12-08 00:00:00 | 39 | DS | [NAME] |  | 2021-01-28 00:00:00
2021-03-22 00:00:00 | 38 | Met | Country |  | 2021-03-24 00:00:00
2021-03-25 00:00:00 | 38 | Met | London
2021-03-25 00:00:00 | 39 | Trans | Hull
Spreadsheet: 99227d1297939107-conditional-formula-nsd3-help
Sheet: CLASS Criteria

CLASS | Criteria |  | Addiotnal Criteria | CLASS
A | If Total 2010 Sales is > | 16000 | But if there was no sales in any 3 consecutive Months | K
B | If [NAME] is between | $8,000 - $15,999 |  | K
C | If [NAME] is between | $5,000 - $14,999 |  | K
D | If [NAME] is between | $2,000 - $4,999 | But if there was no sales in any 3 consecutive Months | H
E | If [NAME] is < | 2000 |  | H
Spreadsheet: 125972d1319452194-which-function-to-copy-data-from-many-sheets-to-a-sheet-in-same-file-monthly-report
Sheet: 2011

STT | Type | Product Name |  |  | Amount | Price | % DISCOUNT |  |  |  | Total | Remarks
 |  | Code | Color Code | Size |  |  | PROMOTION |  | VIP CARD
 |  |  |  |  |  |  | % | Total | % | Total
 |  |  |  |  | (1) | (2) | (3) | (4)=(2)-(3) | (5) | (6)=(2)*(1)-(4)-(5) | (7)=(2)*(1)-(4)-(6)
 | DAY LUNG | RC1071 | 00 | 110 | 1 | 2897000 |  | 0 |  | 0 | 2897000
 | GIAYSS10 | 1585 | 120 | 7.5 | 1 | 1423000 |  | 0 |  | 0 | 1423000
 | GIAYSS10 | 2873 | 125 | 4 | 1 | 1690000 |  | 500000 |  | 0 | 1190000
 | NAM | CH472810 | MKV | 42 | 1 | 2505000 |  | 0 |  | 0 | 2505000
 | NAM | DH354110 | KSN | 4 | 1 | 2141000 |  | 0 |  | 0 | 2141000
 | NAM | L126410 | DRZ | 6 | 1 | 2443000 |  | 0 |  | 0 | 2443000
 | NAM | PH198110 | Q2X | 3 | 1 | 2081000 |  | 0 |  | 0 | 2081000
 | NAM | PH615110 | [NAME] | 5 | 1 | 2287000 |  | 0 | 50 | 1143500 | 1143500
 | NAM | PH820110 | QỤ5 | 5 | 1 | 2069000 |  | 0 |  | 0 | 2069000
 | GIAYSS10 | 1331 | 082 | 7.5 | 1 | 2015000 |  | 0 |  | 0 | 2015000
 | GIAYSS10 | 2811 | 1S9 | 5 | 1 | 1510000 |  | 0 |  | 0 | 1510000
 | GIAYSS10 | 3222 | 098 | 8 | 1 | 3733000 |  | 0 |  | 0 | 3733000
 | NAM | L121210 | S7X | 4 | 1 | 1936000 |  | 0 |  | 0 | 1936000
 | NAM | PH428310 | L0N | 3 | 1 | 2744000 |  | 0 |  | 0 | 2744000
 | NAM | PH428310 | PV3 | 3 | 1 | 2744000 |  | 0 | 10 | 274400 | 2469600
 | NAM | PH539C10 | 68G | 5 | 1 | 2468000 |  | 0 | 10 | 246800 | 2221200
 | NAM | PH665510 | QGD | 5 | 1 | 3119000 |  | 0 |  | 0 | 3119000
 | NAM | PH731910 | 476 | 3 | 1 | 1839000 |  | 0 | 10 | 183900 | 1655100
 | NAM | PH731910 | T01 | 3 | 1 | 1839000 |  | 0 | 10 | 183900 | 1655100
 | NON | RK981310 | 031 | TU | 1 | 621000 |  | 0 | 10 | 62100 | 558900
 |  | PH820110 | U5B | 4 | 1 | 2069000 |  | 0 |  | 0 | 2069000
 |  | RK981310 | [NAME] | TU | 1 | 621000 |  | 0 | 10 | 62100 | 558900
 |  | CH469010 | [NAME] | 40 | 1 | 2886000 |  | 0 |  | 0 | 2886000
 |  | PH820110 | QU4 | 5 | 1 | 2069000 |  | 0 |  | 0 | 2069000
Spreadsheet: barry_tycholiz__830__Denver Cash Mgmt1
Sheet: Denver office

Denver Office Expense Management
ENA OBLIGATIONS
 |  | Expenses Paid to Date | Invoiced Expenses Not Paid | December Weekly Forecast |  |  |  |  |  | 3 Month Subtotal |  |  |  | Next 3 Month Subtotal |  |  |  |  |  |  | 6 Month Subtotal |  | Grand Total
 |  |  |  | WK. 1 Dec. 3 -7 | WK. 2  Dec. 10-14 | WK. 3 Dec. 17-21 | WK. 4 Dec. 24-28 | 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
Recurring Office Expenses
 | Equity Office |  |  |  | 25124.15 |  |  | 25124 | 12000 |  | 12000 | 12000 | 12000 |  | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 |  | 12000
 | Qwest |  |  |  | 604 |  |  | 3500 | 3500 |  | 3500 | 3500 | 3500 |  | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 |  | 3500
 | Qwest |  |  |  | 3179.73 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | AT&T Cellphones |  |  |  |  |  |  | 500 | 500 |  | 500 | 500 | 500 |  | 500 | 500 | 500 | 500 | 500 | 500 |  | 500
 | Misc Office expenses |  |  |  |  |  |  | 1500 | 1500 |  | 1500 | 1500 | 1500 |  | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 |  | 1500
One-time Payments
 | Jaquire Contractors |  |  |  |  | 15280
Employee Specific Expenses
 | Standard Parking |  |  |  | 810 |  |  | 405 | 405 |  | 405 | 405 | 405 |  | 405 | 405 | 405 | 405 | 405 | 405 |  | 405
 | Fitness Reimbursements |  |  |  |  |  |  | 105 | 105 |  | 105 | 105 | 105 |  | 105 | 105 | 105 | 105 | 105 | 105 |  | 104
TOTAL
* If the remaining $15,280 is paid to the contractor, we can finalize our sublease and lower our rent to $12,000
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -945 | -900
2 | -20011 | -20000
3 | -19998 | -20000
4 | -20411 | -20000
5 | -12817 | -9366
6 | -19992 | -19648
7 | -20005 | -19794
8 | -20572 | -20000
9 | -20237 | -20000
10 | -20998 | -20000
11 | -20735 | -20000
12 | -21003 | -20000
13 | -20001 | -20000
14 | -19998 | -20000
15 | -20002 | -19718
16 | -19993 | -19779
17 | -20493 | -20000
18 | -20182 | -20000
19 | -19793 | -19655
20 | -19798 | -19652
21 | -19806 | -19652
22 | -19910 | -19652
23 | -19862 | -20000
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 186823
2002-01-23 00:00:00
CBS Dollars
 |  |  | 199813
Spreadsheet: 456026d1460612982-identifying-formulas-to-use-mutliple-criteria-lookup-and-summing-sample
Sheet: D Group

D Groups
Dgroup 1 | Suburb 1 | Suburb 2 | Suburb 6 | Suburb 7
Dgroup 2 | Suburb 8 | Suburb 9
Dgroup 3 | Suburb 8
Dgroup 4 | Suburb 4 | Suburb 5 | Suburb 9 | Suburb 2
Dgroup 5 | Suburb 8 | Suburb 9
Dgroup 6 | Suburb 3
Spreadsheet: 01911b9e-b5c8-4385-92f0-8dacf051ce21
Sheet: MN Institution Contact Info

To obtain more detailed program and contact information, visit the general website, then locate links to the Education Department.
College/Institution | Location | Telephone Number | Website address
Augsburg College | Minneapolis, MN 55454 | [PHONE] | visit www.augsburg.edu
Bemidji State University | Bemidji, MN 56601 | [PHONE] | visit www.bemidjistate.edu
Bethel University | St. Paul, MN 55112 | [PHONE] | Visit www.bethel.edu
Capella University | Minneapolis, MN 55402 | [PHONE] | visit www.capella.edu
Concordia University - St. Paul | St. Paul, MN 55104 | [PHONE] | visit www.csp.edu
Hamline University | St. Paul, MN 55104 | [PHONE] | visit www.hamline.edu
Minnesota State University - Mankato | Mankato, MN 56002 | [PHONE] | visit www.mnsu.edu
Minnesota State University - Moorhead | Moorhead, MN 56563 | [PHONE] | visit www.mnstate.edu
Southwest Minnesota State University | [NAME], MN 56258 | [PHONE] | visit www.smsu.edu
St. Mary's University | Winona, MN 55987 | [PHONE] | visit www.smumn.edu
University of St. Thomas | St. Paul, MN 55403 | [PHONE] | visit www.stthomas.edu
University of Minnesota - Duluth | Duluth, MN 55812 | [PHONE] | visit www.d.umn.edu
University of Minnesota - Twin Cities | Minneapolis, MN 55455 | [PHONE] | visit www1.umn.edu
St. Cloud State University | St. Cloud, MN 56301 | [PHONE] | visit www.stcloudstate.edu
Walden University | Minneapolis, MN 55401 | [PHONE] | visit www.waldenu.edu
Winona State University | Winona, MN 55987 | [PHONE] | visit www.winona.edu