tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 19403087-85d5-4ea0-b7ad-8e1abe84a784
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
KITAS | Test | KITAS | KIT Asp816Val Mutation Analysis, Qualitative PCR | KIT Asp816Val Mutation Analysis, V | Allele-Specific Oligonucleotide Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  | 2 | mL | The following information is required: 1. Pertinent clinical history 2. Clinical or morphologic suspicion 3. Date of collection 4. Specimen source   Forms: 1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen.   [NAME] must arrive within 168 hours of collection.   Submit only 1 of the following specimens:   Specimen Type: Paraffin-embedded bone marrow aspirate clot Container/Tube: Paraffin block Specimen Stability Information: Ambient/Refrigerated   Specimen Type: Extracted DNA from blood or bone marrow Container/Tube: 1.5- to 20-mL tube with indication of volume and concentration of DNA [NAME] Volume: Entire specimen Collection Instructions: Label specimen as extracted DNA from blood or bone marrow Specimen Stability Information: Refrigerated/Ambient | Extracted DNA from Blood or Bone | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Bone marrow biopsies, slides, or paraffin shavings | An interpretive report will be provided indicating the mutation status as positive or negative. | Monday through Friday | 4 days | 7 days | 1 | 81402 |  |  |  |  | Rochester
KITAS | [NAME] | VARIES | Varies |  |  |  | See instructions
KITAS | Order Question | [NAME] | [NAME] |  | Plain Text
KITAS | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
KITAS | Result | 19507 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
Spreadsheet: 74901d1275439403-macro-to-insert-new-rows-b50book2
Sheet: Sheet1

Location | [NAME] | [NAME] | # | Quantity | Size | Description | Product # | Condition | Product Number
92000 | 22047 | A | 124974 | 50 | 2 | 2 | 2A22047 | X | A, B, C
71000 | 28858 | B | 621276 | 12 | 3 | 3 | 3B28858 | X | A, B
71000 | 28858 | B | 620328 | 12 | 4 | 4 | 4B28858 | X | 3, 5, 7
71000 | 28858 | B | 621565 | 12 | 6 | 5 | 5B28858 | X | G
92000 | 10378 | D | 56796 | 1 | 8 | 6 | 6D10378 | X
92000 | 10378 | D | 388850 | 1 | 9 | 7 | 7D10378 | X | H, I, K
92000 | 10378 | D | 697375 | 1 | 12 | 8 | 8D10378 | X | K
92000 | 10378 | D | 601062 | 1 | 6 | 9 | 9D10378 | X | O, P, L, P,D
71000 | 28858 | C | 103804 | 1 | 6 | 10 | 10C28858 | X | X
71000 | 28858 | C | 103663 | 1 | 7 | 11 | 11C28858 | X | Y
92000 | 10378 | D | 5223 | 50 | 8 | 12 | 12D10378 | X | O, K
93000 | 21469 | E | 529065 | 12 | 12 | 13 | 13E21469 | X | 4, T, P
93000 | 21839 | F | 679043 | 1 | 1 | 14 | 14F21839 | X | 3, I, WE
Spreadsheet: 220962d1363330453-need-help-i-have-to-find-changes-in-data-set-from-a-refernce-sheet-reference
Sheet: Reference sheet

ID No | Car Colour
71924 | Blue
78468 | Blue
78926 | Blue
81318 | Blue
81996 | Blue
82115 | Blue
85738 | Blue
87113 | Blue
90576 | Blue
90656 | Blue
90819 | Blue
91066 | Blue
91308 | Blue
91316 | Blue
91319 | Blue
91326 | Blue
91328 | Blue
91329 | Blue
91335 | Blue
91342 | Blue
91344 | Blue
Spreadsheet: 77824d1278328431-random-number-from-table-random20test
Sheet: data

0.3115401575505805 | 1 | 1
0.6987897533602647 | 2 | 2
 |  | 2
 |  | 2
 |  | 2
0.34096626621929 | 3 | 3
 |  | 3
 |  | 3
0.5305890258917669 | 5 | 5
 |  | 5
0.06772682351314252 | 6 | 6
 |  | 6
 |  | 6
 |  | 6
0.7414385997127344 | 7 | 7
 |  | 7
 |  | 7
 |  | 7
0.005381812650936624 | 8 | 8
0.3968631908262825 | 9 | 9
0.5054521637356235 | 10 | 10
0.1905326422883868 | 11 | 11
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
Spreadsheet: 174094d1344925881-count-non-zero-columns-of-a-range-findnumberofnonzerocolumns
Sheet: Tabelle1

12 | 12 | 21 | 0 |  |  |  |  | Row1
12 | 12 | 12 | 0 |  |  |  |  | Row2
12 | 12 | 12 | 34 |  |  |  |  | Row3
A | B | C | D | E | F | G | H
I would like to get the number "4", because this table has 4 non-zero (or non-empty) columns
Spreadsheet: 724295d1616096498-lookup-for-multiple-values-in-same-column-lookup-help-example
Sheet: Sheet1

 |  |  |  |  | Yellow |  |  |  | Green |  |  | Yellow OR Green Lookup
 |  |  |  |  | ID |  |  |  | ID |  |  | ID
COLOR | DAY | DATE | ID |  | ID |  |  |  | ID |  |  | ID |  |  |  |  |  | Yellow
Yellow |  | 2021-01-04 00:00:00 | 1 |  | ID |  |  |  | ID |  |  | ID |  |  |  |  |  | Green
Yellow |  | 2021-01-10 00:00:00 | 2 |  | ID |  |  |  | ID |  |  | ID
Yellow |  | 2021-01-11 00:00:00 | 3 |  | ID |  |  |  | ID |  |  | ID
Green |  | 2021-01-14 00:00:00 | 4 |  | ID |  |  |  | ID |  |  | ID
Green |  | 2021-01-14 00:00:00 | 5 |  | ID |  |  |  | ID |  |  | ID
Yellow |  | 2021-01-17 00:00:00 | 6 |  | ID
Gray |  | 2021-01-18 00:00:00 | 7 |  | ID
Yellow |  | 2021-01-23 00:00:00 | 8 |  | ID
Yellow |  | 2021-01-23 00:00:00 | 9 |  | ID
Gray |  | 2021-01-23 00:00:00 | 10
Gray |  | 2021-01-23 00:00:00 | 11
Gray |  | 2021-01-23 00:00:00 | 12
Yellow |  | 2021-01-24 00:00:00 | 13
Gray |  | 2021-01-24 00:00:00 | 14
Yellow |  | 2021-01-24 00:00:00 | 15
Gray |  | 2021-01-24 00:00:00 | 16
Gray |  | 2021-01-24 00:00:00 | 17
Gray |  | 2021-01-24 00:00:00 | 18
Gray |  | 2021-01-25 00:00:00 | 19
Gray |  | 2021-01-25 00:00:00 | 20
Gray |  | 2021-01-25 00:00:00 | 21
Yellow |  | 2021-01-26 00:00:00 | 22
Yellow |  | 2021-01-26 00:00:00 | 23
Gray |  | 2021-01-27 00:00:00 | 24
Gray |  | 2021-01-28 00:00:00 | 25
Gray |  | 2021-01-28 00:00:00 | 26
Green |  | 2021-01-28 00:00:00 | 27
Green |  | 2021-01-28 00:00:00 | 28
Green |  | 2021-01-28 00:00:00 | 29
Gray |  | 2021-01-29 00:00:00 | 30
Gray |  | 2021-01-30 00:00:00 | 31
Gray |  | 2021-01-30 00:00:00 | 32
Gray |  | 2021-01-30 00:00:00 | 33
Gray |  | 2021-01-30 00:00:00 | 34
Gray |  | 2021-01-30 00:00:00 | 35
Gray |  | 2021-01-31 00:00:00 | 36
Gray |  | 2021-01-31 00:00:00 | 37
Gray |  | 2021-01-31 00:00:00 | 38
Gray |  | 2021-01-31 00:00:00 | 39
Gray |  | 2021-02-01 00:00:00 | 40
Gray |  | 2021-02-02 00:00:00 | 41
Gray |  | 2021-02-02 00:00:00 | 42
Gray |  | 2021-02-03 00:00:00 | 43
Gray |  | 2021-02-03 00:00:00 | 44
Gray |  | 2021-02-04 00:00:00 | 45
Gray |  | 2021-02-04 00:00:00 | 46
Gray |  | 2021-02-05 00:00:00 | 47
Gray |  | 2021-02-06 00:00:00 | 48
Gray |  | 2021-02-06 00:00:00 | 49
Gray |  | 2021-02-06 00:00:00 | 50
Gray |  | 2021-02-10 00:00:00 | 51
Gray |  | 2021-02-10 00:00:00 | 52
Blue |  | 2021-02-10 00:00:00 | 53
Gray |  | 2021-02-11 00:00:00 | 54
Yellow |  | 2021-02-13 00:00:00 | 55
Gray |  | 2021-02-13 00:00:00 | 56
Blue |  | 2021-02-14 00:00:00 | 57
Blue |  | 2021-02-14 00:00:00 | 58
Yellow |  | 2021-02-14 00:00:00 | 59
Gray |  | 2021-02-14 00:00:00 | 60
Gray |  | 2021-02-14 00:00:00 | 61
Gray |  | 2021-02-14 00:00:00 | 62
Gray |  | 2021-02-14 00:00:00 | 63
Green |  | 2021-02-16 00:00:00 | 64
Green |  | 2021-02-16 00:00:00 | 65
TNT |  | 2021-02-16 00:00:00 | 66
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Chatham

Allardville, NB | 35
Atholville, NB | 116
Baie Sainte Anne, NB | 29
Bathurst, NB | 47
Caraquet, NB | 73
[NAME], NB | 100
Dartmouth, NS | 232
Debert, NS | 175
Duguayville, NB | 63
Fredericton, NB | 119
[NAME], NB | 139
Grande Anse, NB | 75
Kentville, NS | 287
Kingsclear, NB | 130
Lameque, NB | 79
[NAME], NB | 93
Neguac, NB | 29
New Glasgow, NS | 214
New Richmond, QC | 166
Newcastle, NB | 7
[NAME], NB | 124
[NAME], NB | 41
Pokesudie, NB | 79
Rexton, NB | 41
Richibucto, NB | 40
[NAME], NB | 182
Scoudouc, NB | 80
Shippagan, NB | 73
[NAME], NB | 171
Tracadie, NB | 51
Truro, NS | 183
[NAME], PE | 162
Spreadsheet: 38051d1236178490-vat-formula-purchase-order-template-example-doc
Sheet: Sheet1

 |  |  |  |  |  |  |  | 0
PURCHASE ORDER
PO Number: |  |  |  | Cost Code: |  |  |  | Date:
 | Supplier
 | Name: |  |  |  | Tel:
 | Attn: |  |  |  | Fax:
 | Address:
 |  |  |  |  | Your Quotation:
 |  |  |  |  | Job Number:
Item | Qty | Description |  |  |  | Net Value Each | Total Net Value | VAT | Total
EXAMPLE DOCUMENT
1 | 4 | Example Products |  |  |  | 4 | 16 | 2.8 | 18.8
 |  |  |  |  | Totals | 4 | 16 | 2.8 | 18.8
Delivery Date:
Ordered By: |  |  |  |  | Authorised By:
 | Delivery Address:
Registered in Scotland No.151977
VAT No. 632700764
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: Unofficial

 | h'cap | off H'cap | adj | SCORES | POST | Cut | Increase | TOTAL
Number of Players
top two-thirds
Spreadsheet: 151083d1334774768-help-with-if-statement-second-degree-rook-matrix-formation
Sheet: Second Degree Rook Matrix

 | ALLEN | [NAME] | ATCHISON | BARBER | BARTON | BOURBON | BROWN | BUTLER | CHASE | CHAUTAGUGUA | CHEROKEE | CHEYENNE | CLARK | CLAY | CLOUD | COFFEY | COMANCHE | COWLEY | CRAWFORD | DECATUR | DICKINSON | DONIPHAN | DOUGLAS | EDWARDS | ELK | ELLIS | ELLSWORTH | FINNEY | FORD | FRANKLIN | GEARY | GOVE | GRAHAM | GRANT | GRAY | [NAME] | GREENWOOD | HAMILTON | HARPER | HARVEY | HASKELL | HODGEMAN | [NAME] | JEFFERSON | JEWELL | [NAME] | KEARNY | KINGMAN | KIOWA | LABETTE | LANE | LEAVENWORTH | LINCOLN | LINN | LOGAN | LYON | MARION | [NAME] | MCPHERSON | MEADE | MIAMI | MITCHELL | MONTGOMERY | MORRIS | MORTON | NEMAHA | NEOSHO | NESS | NORTON | OSAGE | OSBORNE | OTTAWA | PAWNEE | PHILLIPS | POTTAWATOMIE | PRATT | RAWLINS | RENO | REPUBLIC | [NAME] | RILEY | ROOKS | RUSH | [NAME] | SALINE | SCOTT | SEDGWICK | SEWARD | SHAWNEE | SHERIDAN | SHERMAN | SMITH | STAFFORD | STANTON | STEVENS | SUMNER | THOMAS | TREGO | WABAUNSEE | [NAME] | WASHINGTON | WICHITA | WILSON | WOODSON | WYANDOTTE
allen
[NAME]
atchison
barber
barton
bourbon
[NAME]
butler
chase
chautagugua
cherokee
[NAME]
clark
clay
cloud
coffey
comanche
cowley
crawford
decatur
[NAME]
doniphan
[NAME]
edwards
[NAME]
[NAME]
ellsworth
[NAME]
ford
franklin
geary
gove
[NAME]
grant
gray
[NAME]
greenwood
[NAME]
harper
harvey
haskell
hodgeman
[NAME]
[NAME]
jewell
[NAME]
kearny
kingman
kiowa
labette
lane
[NAME]
lincoln
[NAME]
logan
lyon
marion
[NAME]
[NAME]
meade
miami
mitchell
montgomery
[NAME]
morton
nemaha
neohso
ness
norton
osage
osborne
ottawa
pawnee
phillips
[NAME]
pratt
rawlins
reno
republic
rice
riley
rooks
rush
russell
saline
[NAME]
sedgwick
seward
shawnee
sheridan
sherman
[NAME]
[NAME]
stanton
[NAME]
sumner
[NAME]
trego
wabaunsee
[NAME]
washington
wichita
wilson
woodson
wyandotte
Spreadsheet: 814794d1674594568-if-and-with-multiple-condition-sp-part-form
Sheet: Sheet1

Item Number | Last_Trx_Date | Onhand Value | SID | ARROW | SP PART | SP PART Supposed to be
P26969-05N | 2022-12-21 00:00:00 | 19 |  |  |  | 9.5 | if [NAME] has -N (N after dash), B2 is less than 12 months from 12/31/2022 and [NAME] is 0 and E2 is 0 multiply C2 by 50%
P27801-02N | 2018-01-25 00:00:00 | 27 |  |  |  | 20.25 | if [NAME] has -N (N after dash), B2 is more than 12 months from 12/31/2022 and [NAME] is 0 and E2 is 0 multiply C2 by 75%
P29697-01 | 2021-07-29 00:00:00 | 185 |  |  |  | 0 | if [NAME] has no -N (N after dash), G2 is 0
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Worker's comp |  | -30859 |  | 30859
Group insurance |  | 33825 |  | -33825
Accrued bonus/commissions |  | -202500 |  | 202500
Accrued 401(k) |  | -9823 |  | 9823
Payroll taxes |  | -74501 |  | 74501
Accrued sales and use tax |  | -56221 |  | 56221
Misc |  | -6054 |  | 6054
Post retirement |  | -14208 |  | 14208
Acquisitin payroll clearing |  | -18415 |  | 18415
Unclaimed wages |  | -207 |  | 207
[NAME] |  | 0 |  | -1093143 |  |  |  | 4538712
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 196978d1354175521-min-max-axis-options-issue-songlengthsvswekscharted
Sheet: 2001

Artist | [NAME] | [NAME] | Weeks Charted
Lifehouse | Hanging By a Moment | 03:36:00 | 47
Train | Drops of Jupiter | 04:20:00 | 42
Staind | It's Been Awhile | 04:25:00 | 38
Toya | I Do!! | 03:31:00 | 31
[NAME] | Fallin' | 03:30:00 | 29
[NAME] (feat. [NAME]) | I'm Real | 04:22:00 | 26
Enya | Only Time | 03:39:00 | 25
[NAME] | The Star Spangled Banner | 02:15:00 | 25
[NAME] | Can't Fight the Moonlight | 03:36:00 | 24
[NAME] | Family Affair | 04:26:00 | 23
Spreadsheet: 870107d1716627653-help-make-a-formula-adding-ingredient-unit-conversion_carton_box_pump_cup-choy96-3-
Sheet: Sheet1

1 carton | = | 16 box
1 box | = | 5 pump | 15
1 pump | = | 3 cup
office balance | worker 1 | worker 2 | worker 3 | worker 4 | worker 5 | total |  | ca | b | p | cu | Mod(Cu,3) | Sum(P,Mod(Cu,3)) | Mod(P,5) | Sum(B,[NAME])) | [NAME]) | Sum(Ca,[NAME]))
0 | 0 | 1ca | 4p | 4p | 3ca 10b 0p 1cu
0 | 0 | 0 | 0 | 0 | 3ca 0b 3p 1cu
 |  |  | 1ca 11b 1p | 3b | 3b
 |  |  | 99b
 |  |  | 100b
Spreadsheet: 61759d1262691707-separate-an-alphanumeric-cell-into-its-components-excel-problem-1
Sheet: Sheet1

 | input : mixed address cells | output : city , street, st number and zip in separate cells |  |  |  |  |  | list of cities which can appear in mixed address cells
 |  |  |  |  |  |  |  | san diego
 |  | city | street | street number | [NAME] |  |  | chicago
 | 98 ironwood street rochester 48063 | rochester | ironwood | 98 | 48063 |  |  | [NAME]
 | chesterfield 55 street , Chicago 55660 | chicago | chesterfield | 55 | 55660 |  |  | rochester
 | 76 drexler , Bozman , 33087 | bozeman | drexler | 76 | 33087 |  |  | bozeman
 | Collins 230, [NAME] | [NAME] | [NAME] | 230 |  |  |  | new york
 | [NAME] 221 | San Diego | [NAME] | 221 |  |  |  | etc
 |  | I need a function which can produce the blue outcome
 |  | order and location of numbers and texts in address cells is not fixed :
 |  | 98 ironwood rochester 48063
 |  | rochester 48063 ironwood 98
 |  | [NAME] is always 5 digit number
 |  | street number is 3 digit or less
Spreadsheet: 83351d1283344784-show-when-a-student-has-a-mark-updated-in-a-column-with-their-orginals-practiceplz
Sheet: Termone

 |  |  | MM |  |  | SP
 |  |  | Cwrk | Exam | Total | Cwrk | Exam | Total
 |  | a100 | 50 | 33 |  | #N/A | #N/A
 |  | a200 | 52 | 32 |  | 32 | 53
 |  | a300 | 44 | 24 |  | 30 | 43
 |  | a400 | NS | NS |  | NS | NS
 |  | a500 | 40 | 35 |  | #N/A | #N/A
 |  | a600 | NS | NS |  | NS | NS
 |  | a700 | 44 | 32 |  | #N/A | #N/A
 |  | a800 | 30 | 40 |  | 27 | 57
Spreadsheet: 746255d1630593543-solver-excel-problem-how-to-create-the-optimal-boxes-mix-to-respect-the-constrains-best_boxes-hydr-
Sheet: Foglio1

I want to pay the cheaper amount possible to send all the itens listed above (total 64). I have the freight value in the table below and I have the constraint that all boxes need to be less than $50 to avoid the import tax fee. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DivingS | On
TAX FEE
All the boxes need to be less than $50, otherwise I will 60% of tax fee.
Standard Freight
Pounds | Cost
0 - 1 | 18.98
 | 28.98
 | 38.98
 | 48.98
The problem
Minimize the number of boxes to reduce freight costs and also avoid tax fee
Product | Quantity I have | Box1 | Box2 | Box3 | Box4 | Box5 | Box6 | Box7 | Box8 | Box9 | Box10 | Box11 | Box12 | [NAME] | Box14 | Box15 | Box16 | Unit Pounds | Total Pounds | Unite price | Total Cost
ITEM #1 | 6 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0.1433 |  | 4.99
ITEM #2 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 0 | 0.2033 |  | 10
ITEM #3 | 3 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.71 |  | 8.7
ITEM #4 | 3 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1467 |  | 34
ITEM #5 | 5 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0.356 |  | 29.5
ITEM #6 | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0.2033 |  | 7.2
ITEM #7 | 3 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1633 |  | 30
ITEM #8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0.1133 |  | 7.9
ITEM #9 | 5 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.376 |  | 9.99
ITEM #10 | 5 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0.278 |  | 7.7
ITEM #11 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0.106 |  | 6.99
ITEM #12 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0.2033 |  | 5.9
ITEM #13 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 0 | 0.166 |  | 9.99
ITEM #14 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.2033 |  | 9.8
TOTAL
 | 18.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
shipping costs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n° boxes
extra fee |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 34045d1231165196-sumif-with-subtotals-tier-problem
Sheet: Sheet1

Tier | Country | Amount Payable
3 | GER | 100
3 | GER | 124
5 | GER | 124
4 | GER | 135
3 | GER | 135
6 | GER | 135
5 | GER | 142
7 | GER | 142
4 | GER | 143
6 | IRE | 106
8 | IRE | 108
5 | IRE | 115
9 | IRE | 115
3 | IRE | 120
5 | IRE | 124
4 | IRE | 124
1 | IRE | 143
2 | IRE | 146
9 | IRE | 150
8 | IRE | 150
7 | UK | 110
7 | UK | 110
5 | UK | 110
7 | UK | 115
6 | UK | 115
8 | UK | 120
2 | UK | 120
4 | UK | 150
2 | UK | 155
4 | UK | 155
 | Total | 2091
Total | GER | 1180
Total | IRE | 1401
Total | UK | 1260
Spreadsheet: 794915d1662396942-random-number-with-condition-rand-eq-sum
Sheet: Sheet1

 |  | rand
 |  |  | B3: =ROUND(C3*$B$31/1000/$C$28, 0)*1000
 |  |  | [NAME]: =[NAME]()
 |  |  | B27: =B31 - SUM(B3:B26)
sum |  |  | C27: =SUM(C3:C27)
goal | 53648000
Spreadsheet: 6afa3e9b-2c76-4013-b41e-fb203ed41dd2
Sheet: CAPEX

Back to Index
CAPEX
Capital Expenditures for Continuing Operations
(In thousands)
 | Q1 | Q2 | Q3 | Q4 | YTD
2012 | 38007 | 38694 | 56480 | 74873 | 208054
2011 | 38472 | 49405 | 46902 | 44457 | 179236
2010 | 31517 | 52822 | 48135 | 38375 | 170849
2009 | 34987 | 38288 | 28647 | 46545 | 148467
2008 | 28182 | 34653 | 47692 | 33525 | 144052
Spreadsheet: 5edd5d59-b5d1-43c6-bb0c-75f97d7ddcc5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5606 | 7974 | [NAME] | [NAME] | USA | 0 | 00:40:34 | 00:09:34 | 01:23:56 | [NAME] | 01:14:20 | 1 | 03:34:29
5606 | 39134 | [NAME] | [NAME] | USA | 0 | 01:07:42 | 00:14:24 | 01:41:17 | 00:07:49 | 00:58:09 | 2 | 04:09:24
Spreadsheet: a32fc968-7946-4097-95ca-f41a2fd6b7ec
Sheet: Sheet1

IRN | Organization | County | Amount of Subaward | Disbursed | Organization Type
43489 | Akron City | Summit | 3233966.5 | 1300831.63 | Public District
43711 | Canton City | [NAME] | 335171 | 31373.86 | Public District
43752 | Cincinnati City | [NAME] | 15331063.75 | 6568654.71 | Public District
43794 | Cleveland Heights-University Heights City | Cuyahoga | 1344622 | 769194.1600000001 | Public District
43786 | Cleveland Municipal | Cuyahoga | 21603173.85 | 10480674.05 | Public District
420 | Columbus Bilingual Academy | Franklin | 253778 | 99959.39 | Community School
43802 | Columbus City School District | Franklin | 19445336 | 7674251.550000001 | Public District
143412 | Crittenton Community School | Franklin | 451500 | 321455.3 | Community School
43844 | Dayton City | Montgomery | 7067873.46 | 2416165.41 | Public District
43901 | East Cleveland City School District | Cuyahoga | 1459400 | 0 | Public District
134288 | East End Comm Heritage School | [NAME] | 353925.25 | 248870.38 | Community School
44222 | Lima City | [NAME] | 2907018.06 | 2142951.07 | Public District
8066 | Lion of Judah Academy | Cuyahoga | 221385 | 69718.85 | Community School
44297 | Mansfield City | Richland | 913019.8 | 274754.28 | Public District
396 | Mansfield Elective Academy | Richland | 395034 | 39500 | Community School
44412 | Mt Healthy City | [NAME] | 2427441 | 1260722.03 | Public District
142950 | Ohio Virtual Academy | Lucas | 687000 | 196520.82 | Community School
9178 | Romig Road Community School | Summit | 975450 | 324862.62 | Community School
277 | Scholarts Preparatory and Career Center for Children | Franklin | 1000000 | 671088.02 | Community School
46441 | Southern Local | [NAME] | 1225941.65 | 434617.95 | Public District
44818 | Springfield City | [NAME] | 3194000 | 1813962.71 | Public District
296 | Summit Academy Columbus | Franklin | 532902 | 103236.73 | Community School
304 | Summit Academy Community School-Toledo | Lucas | 438723 | 136661.06 | Community School
297 | Summit Academy Dayton | Montgomery | 350588 | 87818.29000000001 | Community School
610 | Summit Academy Middle School - Columbus | Franklin | 300773 | 50462.15 | Community School
609 | Summit Academy Middle School - Lorain | Lorain | 237092 | 46694.32 | Community School
133322 | Summit Academy-Lorain | Lorain | 425559 | 95405.06 | Community School
623 | Summit Academy-Youngstown | Mahoning | 311721 | 88898.49999999999 | Community School
44909 | Toledo City | Lucas | 5718322.72 | 0 | Public District
148981 | Tomorrow Center | Morrow | 789357 | 461298.16 | Community School
45922 | Trimble Local | Athens | 662585 | 437907.01 | Public District
909 | V L T Academy | [NAME] | 1583652 | 530450.68 | Community School
143537 | Virtual Community School Of Ohio | Franklin | 996500 | 258859.57 | Community School
564 | Virtual Schoolhouse, Inc. | Cuyahoga | 264869.4 | 65033.70999999999 | Community School
45153 | Xenia Community City | Greene | 4073254.3 | 2842559 | Public District
45161 | Youngstown City Schools | Mahoning | 4903176 | 2217902.09 | Public District
 |  |  | 106415173.74 | 44563315.12
Spreadsheet: 772315d1647196206-if-function-too-many-arguments-feature-valuation
Sheet: Features

 |  |  | Usage/Engagement | Monetization
 | Feature | Component | (% of users) | (% users that renew) | Usage | Monetization | Value index
 |  |  | 0.7 | 0.5