tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19066__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-10 00:00:00 |  | 181.91 | 26368 | 109.27 | 11712
 | 2001-04-09 00:00:00 |  | 157.87 | 22000 | 113.76 | 15928
 | 2001-04-08 00:00:00 |  |  |  |  |  | 113.77 | 45888
 | 2001-04-07 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
Spreadsheet: rick_buy__32857__DOUG
Sheet: 0300

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF MARCH 31, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 10862564.92 |  | 0 |  | 1539 |  | 4368505.61 |  | 5699257.73 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 8978874.26
PUERTO QUETZAL | A/R |  |  |  | 4400091.83 |  | 0 |  | 0 |  | 444405.91 |  |  | LAST PAYMENT 2/28/00
463 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
416 | PER CENT
DABHOL POWER CO | A/R |  | 195872.9 |  | 4011.82 |  | 144874.81 |  | 0 |  |  |  |  | LAST PAYMENT 3/13/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 144874.81
EMPRESA ENERGETICA | A/R |  | 0 |  | 1559976.76 |  | 1217777.54 |  | 1581340.62 |  | -189.2 |  |  | LAST PAYMENT 3/9/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1100305.79
EGEMINSA | A/R |  | 126549.55 |  | 613143.35 |  | 1138414.35 |  | 536193.6 |  | 671682.55 |  |  | LAST PAYMENT 3/22/00
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1063696.02
TOTALS | A/R
 | PER CENT
Spreadsheet: 169232d1342734248-counting-dates-date-eomonth-calculation
Sheet: Summary

Month | Leases Expiring
2012-08-31 00:00:00
2012-09-30 00:00:00
2012-10-31 00:00:00
2012-11-30 00:00:00
2012-12-31 00:00:00
2013-01-31 00:00:00
2013-02-28 00:00:00
2013-03-31 00:00:00
2013-04-30 00:00:00
2013-05-31 00:00:00
2013-06-30 00:00:00
2013-07-31 00:00:00
Spreadsheet: 1c26870e-7c11-4f6e-877a-3c6ac4b99aa8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
1972 | 5566 | Rika | Takahashi | JPN | 0 | 00:21:50 | 00:00:00 | 01:09:14 | 00:00:00 | 00:41:12 | 1 | 02:12:16
1972 | 6336 | Keiko | [NAME] | JPN | 0 | 00:20:41 | 00:00:00 | 01:10:15 | 00:00:00 | 00:44:39 | 2 | 02:15:35
1972 | 6459 | [NAME] | Matsumoto | JPN | 0 | 00:24:17 | 00:00:00 | 01:14:16 | 00:00:00 | [NAME] | 3 | 02:18:14
1972 | 6457 | Yayoi | Ito | JPN | 0 | 00:21:21 | 00:00:00 | 01:10:13 | 00:00:00 | 00:48:54 | 4 | [NAME]
1972 | 6458 | Naoko | Hasegawa | JPN | 0 | [NAME] | 00:00:00 | 01:12:58 | 00:00:00 | [NAME] | 5 | 02:24:47
1972 | 9259 | Ruriko | Yajima | JPN | 0 | 00:27:05 | 00:00:00 | 01:15:32 | 00:00:00 | [NAME] | 6 | 02:30:05
1972 | 6456 | [NAME] | Ohtsuka | JPN | 0 | 00:22:55 | 00:00:00 | 01:15:35 | 00:00:00 | 00:55:23 | 7 | [NAME]
Spreadsheet: 770494d1646122622-o365-reorder-columns-in-dynamic-arrray-ef-query
Sheet: Sheet2

 |  |  |  |  |  | Desired result in one fromula
AAA | A Comment | 9 |  |  |  |  | A Comment |  | 63 | 42 | 42 | 30 | 71 | 91 | 34 | 97
AAA | A Comment | 63 |  |  |  | BBB | B Comment | 30 | 30 | 69 | 18 | 55 | 46 | 6 | 28 | 97
AAA | A Comment | 42 |  |  |  | CCC | C Comment | 78 | 95 | 89 | 41 | 13 | 37 | 87 | 91 | 64
AAA | A Comment | 42
AAA | A Comment | 30
AAA | A Comment | 71
AAA | A Comment | 91 |  |  |  |  | A Comment | 42 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
AAA | A Comment | 34 |  |  |  | BBB | B Comment | 69 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
AAA | A Comment | 97 |  |  |  | CCC | C Comment | 89 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
BBB | B Comment | 30
BBB | B Comment | 30
BBB | B Comment | 69 |  |  |  |  | 63 | 42 | 42 | 30 | 71 | 91 | 34 | 97 | #N/A | #N/A
BBB | B Comment | 18 |  |  |  | 30 | 30 | 69 | 18 | 55 | 46 | 6 | 28 | 97 | #N/A | #N/A
BBB | B Comment | 55 |  |  |  | 78 | 95 | 89 | 41 | 13 | 37 | 87 | 91 | 64 | #N/A | #N/A
BBB | B Comment | 46
BBB | B Comment | 6 |  |  |  |  | 63 | 42 | 42 | 30 | 71 | 91 | 34 | 97 | #N/A
BBB | B Comment | 28 |  |  |  | BBB | 30 | 69 | 18 | 55 | 46 | 6 | 28 | 97 | #N/A
BBB | B Comment | 97 |  |  |  | CCC | 95 | 89 | 41 | 13 | 37 | 87 | 91 | 64 | #N/A
CCC | C Comment | 78
CCC | C Comment | 95
CCC | C Comment | 89
CCC | C Comment | 41
CCC | C Comment | 13
CCC | C Comment | 37
CCC | C Comment | 87
CCC | C Comment | 91
CCC | C Comment | 64
Spreadsheet: 82683d1282719771-four-way-lookup-book1
Sheet: Sheet1

Driver | Class | Transpo | Gas Cost |  |  |  |  |  | CAR |  |  | TRUCK |  |  | BIKE
PC | A | Car | 1500 |  |  |  |  |  | A | B | C | A | B | C | A | B | C
PC | B | Truck | 1600 |  |  |  |  | PC
CC | C | Truck | 1700 |  |  | ??? |  | CC
CC | A | Car | 1800 |  |  |  |  | MM
MM | B | Bike | 1900
MM | C | Bike | 2000
How do you automatically lookup the gas cost to be reflected to the next table???
I tried using index match but it did not work.
Please help.
Spreadsheet: 599782d1543313289-formulas-for-error-messages-honda-servicing-guide
Sheet: Wrong

 |  |  |  |  |  | HONDA SERVICING
 |  |  |  |  |  |  |  | Model | Age | Fuel Type | Mileage | Transmission |  | 1.Select Vehicle, age, fuel type and mileage
 |  |  |  |  |  |  |  | Jazz | 1 | Petrol | 25000 | Manual
When selecting "Sport" Models, valve clearance will show up on age 2,4,6 they are for TYPE R's only |  | "Sport" Models include: Civic TYPE R, NSX AND S2000. Remember that Sports models use diesel pricing
 |  |  |  |  |  | SERVICES |  |  |  |  |  |  |  | 2. Relevant services will be highlighted
 |  |  |  |  |  | SERVICE DUE | S12 | S25 | S37 | [NAME] | SH2
 |  |  |  |  |  | TIME | 1.5 | 1.5 | 2 | 1.5 | 1.5
 |  |  |  |  |  | SERVICE DUE | SH1D | SH2D
 |  |  |  |  |  | TIME | 1.5 | 2
ALWAYS CHECK CRV'S TO SEE IF THEY ARE 4WD ON EXPERIAN. IF THEY ARE 4WD THEN YOU NEED TO CHARGE DIESEL PRICES EVEN IF THEY ARE PETROL CARS |  | When selecting Sports models, petrol and diesel services may highlight. ALWAYS CHARGE FOR DIESEL FOR SPORTS MODELS |  |  |  | ADDITIONAL WORK |  |  |  |  |  |  |  | 3. Relevant extra items will be highlighted
 |  |  |  |  |  | Air Filter £50 | Pollen Filter £48 | Petrol Fuel Filter £160 | Diesel Fuel Filter £116 | 4 x Iridium Spark Plugs £160 | Valve Clearance £100
 |  |  |  |  |  | Manual Gearbox Oil £85 | Auto Box Fluid £85 | CVT Fluid £85 | [NAME] £35 | Transfer Box Oil £85 | Rear Differential Oil £85
 |  |  |  |  |  | Brake Fluid £65 | 4 x Steel Spark Plugs £90 | 8 x Steel Spark plugs £180 (Jazz 2009 or older only) | Coolant Change £85
Spreadsheet: 3f347318-cde7-4437-8cb9-8084a12522fc
Sheet: Sheet1

NOTE: This form may be e-mailed to [NAME] ([EMAIL])  when you have no receipts to turn in.
If you have receipts, they MUST be submitted before this form will be processed.  Please print this form and submit it with your receipts.
TRAVEL AND EXPENSE REPORT
Georgia-Cumberland Conference
Name: |  |  |  |  |  | Date
Address:
 |  |  | A | B | C | D |  | E |  | F
Date | From/to Destination | Reason for Expenditure | Special Miles | Per Diem ** | Motel | Misc. Exp. | Misc. Explanation | Entertain.  Expense | Entertainment Explanation | Travel Exp. Air, Rent, etc.
Sub Total
TOTALS
Notes to Treasury: |  |  |  |  | Treasury Use Only
 |  |  |  |  | A | Special Mileage |  | 11200
 |  |  |  |  | B | Per Diem |  | 11201
 |  |  |  |  | C | Motel |  | 11202
 |  |  |  |  | E | Entertainment |  | 11205
 |  |  |  |  | D | Misc Travel Non-Tax |  | 11206
 |  |  |  |  | F | Reg. Travel Airfare, Non-Tax. |  | 11209
 |  |  |  |  |  | Professional Allowance |  | 11603
Employee Signature:
Treasury Authorization:                                           Date:
Spreadsheet: 487182d1477952500-array-small-and-or-function-extract-data-for-given-date-copy-of-copy-of-product_list-1
Sheet: all

 |  |  |  |  |  |  | vacation 1-st part |  |  |  |  | vacation 2-nd part |  |  |  |  | vacation 3-rd |  |  |  |  | vacation 4-th part
р.бр. | name | section | religious holiday | whole vacation | vacation left |  | no of days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end
1 | employe 1 | 1 | 2016-11-21 00:00:00 | 25 |  |  | 10 | 2016-11-18 00:00:00 |  |  |  | 5 | 2016-12-26 00:00:00
 | employe 2 | 2 | 2016-11-22 00:00:00 | 25 |  |  | 15 | 2016-08-12 00:00:00
 | employe 3 | 1 | 2016-11-23 00:00:00 | 25 |  |  | 15 | 2016-07-25 00:00:00
 | employe 4 | 3 | 2016-11-24 00:00:00 | 25 |  |  | 10 | 2016-09-15 00:00:00 |  |  |  | 10 | 2016-07-25 00:00:00
 | employe 5 | 1 | 2016-11-25 00:00:00 | 25 |  |  | 10 | 2016-07-01 00:00:00
 | employe 6 | 4 | 2016-11-26 00:00:00 | 25 |  |  | 10 | 2016-07-15 00:00:00 |  |  |  | 5 | 2016-09-15 00:00:00
 |  |  |  |  |  |  | I can make it to work between I and K columns but I don't know how to add other ranges and how to exclude #num values from list belowe
 | for a date:
 | 2016-07-26 00:00:00
Spreadsheet: 808224d1670354530-count-fields-based-on-month-ortho-ed-and-discharge-new
Sheet: Jan

Description | BMI > 40 | Total ASA 3 | Total ASA 4 | ALOS | Median | Totals
Total Knee - 1
Total Hip - 2
Total Shoulder - 3
Spine - 4
Bilat. Total Knee - 5
Bilat. Total Hip - 6
Spreadsheet: john_lavorato__16469__John Lavorato Transfer Info and Summary - 2
Sheet: Sheet1

Summary of Payments made to [NAME]
Reconciliation for Invoicing and Payroll Purposes
Transferred to Houston April 16th but remained on Canada Payroll until June 15th.
April 16-30 |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7713.52 | plus expense payment
May 1-15 |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7795.37
May 16-31 |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7795.37 | plus expense payment
June 1-15 |  | Vacation Pay | 12308.56 | paid by auto deposit
 |  | Net Pay: | 7329.23
June 14th |  | Regular | 12122.5
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL: | 14985.85
 |  | NET: | 7823 | paid by manual cheque
 |  |  |  | deposited by [NAME] on June 14th
Sign-On Payment |  | USD | 100000 | f/x rate of: | 1.4978
June 1st |  | CAD
 |  | less taxes: | -65903.2
 |  | NET:
 |  | converted to USD: |  | paid by manual cheque
June 2nd |  | USD | 21000 | f/x rate of: | 1.4978
 |  | CAD
 |  | less taxes: | -13839.67
 |  | NET:
 |  | converted to USD: |  | paid by manual cheque
Retroactive Payment re: Sign On
US Agreement: |  |  | per pay period: |  | 12500
 |  |  | f/x rate: |  | 1.4978
 |  |  | total per pay:
 |  |  | 4 Pay periods owing:
 |  |  | plus 21% gross up:
 |  |  | TOTAL OWING:
Total paid for regular salary (Apr 16-June 15): |  |  |  |  | -59943.4
Retroactive Payment made on June 14th: |  |  |  |  | -8046.6
:this was done by manual cheque and deposited manually June 14th
TOTAL PAYMENT OWING RE: SIGN-ON AGREEMENT:
less tax: |  |  |  |  | -12671.064
NET PAYMENT: |  |  |  |  |  | paid by manual cheque
 |  |  |  |  |  | deposited to TD account
 |  |  |  |  |  | on June 20th
Spreadsheet: 28e573ae-e808-4a58-ad0d-92457eb646da
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Burkhardtsdorf - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 976 | 975 | 932 | 857
20 - 65 | 3849 | 3500 | 3099 | 2800
65 und mehr | 1531 | 1592 | 1719 | 1776
Insgesamt | 6356 | 6067 | 5750 | 5433
%
unter 20 | 15.35556954059157 | 16.07054557441899 | 16.20869565217391 | 15.77397386342721
20 - 65 | 60.55695405915669 | 57.68913795945277 | 53.89565217391304 | 51.53690410454629
65 und mehr | 24.08747640025173 | 26.24031646612823 | 29.89565217391305 | 32.68912203202651
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 25.35723564562224 | 27.85714285714286 | 30.07421748951274 | 30.60714285714285
Altenquotient | 39.77656534164718 | 45.48571428571429 | 55.46950629235236 | 63.42857142857142
Gesamtquotient | 65.13380098726942 | 73.34285714285714 | 85.54372378186513 | 94.03571428571429
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 127879d1320670173-preparing-a-summary-from-standardised-data-across-many-worksheets-planner-spreadsheet
Sheet: Summary

 |  |  |  |  | 2011-01-01 00:00:00 | 2011-01-08 00:00:00 | 2011-01-15 00:00:00 | 2011-01-22 00:00:00 | 2011-01-29 00:00:00 | 2011-02-05 00:00:00 | 2011-02-12 00:00:00 | 2011-02-19 00:00:00
 |  | Start | End
 | Angola | 2011-01-15 00:00:00 | 2011-01-29 00:00:00 |  |  |  | 2011-01-15 00:00:00 | 2011-01-22 00:00:00 | 2011-01-29 00:00:00
 | Albania | 2011-01-23 00:00:00 | 2011-02-06 00:00:00 |  |  |  |  | 2011-01-22 00:00:00 | 2011-01-29 00:00:00 | 2011-02-05 00:00:00
 | Algeria | 2011-02-05 00:00:00 | 2011-02-11 00:00:00 |  |  |  |  |  |  | 2011-02-05 00:00:00
Spreadsheet: 117102d1312453016-excel-2007-too-many-if-statements-enter-account-manager-name-depending-on-adjacent-cell-text-786905-too-many-if-statements-xlquery
Sheet: Transactions

Client | Account Manager
Client 1 |  | =VLOOKUP($A3,'Customer Base'!$A:$B,2,FALSE)
Client 1 |  | and copy down
Client 1
Client 1 |  | Named range:  =ClientList
Client 1 |  | refers to: ='[NAME]
Client 1 |  | used for data validation
Client 1
Client 1
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 2
Client 5
Spreadsheet: 153250d1335826525-auto-sort-values-drawn-from-a-vlookup-table-into-ascending-order-sortingexample1
Sheet: VLookupTable

NJ | 0.4141129714107488 | 36
Hou | 0.5346784547152194 | -11
[NAME] | 0.5824151019675501 | 8
Chi | 0.5307337384377362 | -2
Cha | 0.4086588162660472 | 6
NJ | 0.4141129714107488 | 5
Ind | 0.5185801965749602 | -12
Phi | 0.5187353113032686 | -14
Mil | 0.4996112879733603 | 5
SA | 0.5645287340138865 | -22
[NAME] | 0.4623480392349345 | 6
NO | 0.4319737213932251 | 22
Tor | 0.4082945997171938 | 23
Orl | 0.5195090607139831 | 2
LAL | 0.5830781964115567 | -8
[NAME] | 0.4502741585543951 | 2
Por | 0.5264521796059863 | -20
Chi | 0.5307337384377362 | -11
NY | 0.4661486876370821 | -17
Spreadsheet: louise_kitchen__24239__2002 Plan Group Expense Summary 2
Sheet: Headcount

 | Gas Trading Headcount changes
 |  |  |  |  | 2000 Actuals |  | 2001 Plan |  | [NAME]
 | West Gas |  |  |  | 13 |  | 15
 | MW Gas |  |  |  | 22 |  | 36
 | East Gas |  |  |  | 27 |  | 31
 | Texas Gas |  |  |  | 19 |  | 20
 | Financial Trading |  |  |  | 10 |  | 9
 | Derivatives |  |  |  | 19 |  | 24
 | Upstream Origination |  |  |  | 55 |  | 95
 | Bridgeline |  |  |  | 0 |  | 0
 | HPL |  |  |  | 88 |  | 90
 | Natural Gas Commodity Structuring |  |  |  | 12 |  | 14
 | Fundamentals |  |  |  | 11 |  | 15
Spreadsheet: kate_symes__19085__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-12 00:00:00 |  | 163.9 | 4464 | 96.03 | 2832
 | 2001-04-11 00:00:00 |  | 186.25 | 640 | 102.5 | 400 | 146.66 | 1921 | 101.73 | 1672
 | 2001-04-10 00:00:00 |  | 189.32 | 1184 | 98.94 | 1440 | 146.67 | 2390 | 93.48 | 1552
 | 2001-04-09 00:00:00 |  | 126.46 | 2896 | 105.72 | 1264 | 122.88 | 1015 | 86.46 | 925
 | 2001-04-08 00:00:00 |  | 130 | 0 | 98 | 0 | 97.91 | 2833 | 87.85 | 1659
 | 2001-04-07 00:00:00 |  | 183.6 | 2576 | 92.82 | 1704 | 114.42 | 1980 | 114.75 | 800
 | 2001-04-06 00:00:00 |  | 183.6 | 2576 | 92.93 | 1680 | 147.71 | 1463 | 91.2 | 1429
 | 2001-04-05 00:00:00 |  | 200.55 | 5984 | 102.44 | 2408 | 127.14 | 2549 | 98.45 | 1862
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232 | 148.64 | 1692 | 81.66 | 1580
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
Spreadsheet: 103491d1301253346-resulting-value-based-on-multiple-criteria-using-formulas-budget_spreadsheet2011_new
Sheet: PO

PHS Wastemanagement Budget Spreadsheet
 | Total Budget | 35000 |  | Split as Dynamics Spend | 5000
 | Total Budget Spent | 10000 |  | Split as Waste Spend | 5000
 | Total Budget Remaining | 25000 |  | [NAME] | 10000
 | Date | Type | Supplier | Item Description | Value | PO No | GRN | Date on System | Period Booked |  | Accounts Date
D |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
W |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
D |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
W |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
D |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
D |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P1
D |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P3
W |  | Directory |  |  | 1000 |  |  |  | P1 |  | P2
W |  | Directory |  |  | 1000 |  |  |  | P1 |  | P3
W |  | Design/Print |  |  | 1000 |  |  |  | P1 |  | P2
 |  |  |  | Total Spend Value | 10000
 | Type
 | Advert - Print
 | Advert - Web
 | Design/Print
 | Directory
 | DM - Mailing
 | DM - Packing
 | [NAME]
 | Exhibition
 | PPC
 | PR
 | Print
 | [NAME]
 | Seminar
 | Web Link
 | Website Design
 | Accounts Dates
 | P1
 | P2
 | P3
 | P4
 | P5
 | P6
 | P7
 | P8
 | P9
 | P10
 | P11
 | P12
 | P13
Spreadsheet: 835180d1688388275-calculating-running-percentage-for-rows-with-blank-cells-but-will-be-populated-feedback-stats
Sheet: 2023

 | Respondent identity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  |  |  |  |  |  |  |  | TOTAL | out of a total score of ??? | Average | Median | Mode
1 | Timeliness of papers (did you have enough time to read them etc?) | 3 | 4 | 4 | 5 | 5 | 5 | 4 | 2 | 4 | 5 | 5 | 3 | 5 | 3 | 5 | 3
2 | Information about the meeting (enough and in time) | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5
3 | How easy was it to find the venue / join the virtual meeting? | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 5 | 5 | 4 | 4
4 | How did you find the room layout? | 4 | 4 | 5 | 4 | 4 | 4 | 5 | 3 | 3 | 4 | 5 | 5 | 5 | x | 3 | 3
5 | How did you find the refreshments and catering? | 4 | 5 | 4 | 4 | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 5 | 5 | x | 5 | 4
6 | How did you find the venue environment, eg  temperature, accessibility, facilities? | 4 | 4 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 5 | x | 4 | 3
7 | How was the timing of the meeting? | 5 | 4 | 4 | 5 | 4 | 4 | 3 | 2 | 4 | 4 | 5 | 5 | 5 | x | 5 | 2
8 | Was the information presented easy to understand? | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 5 | 4 | 5 | x | 5 | 4
9 | Were the presenters easily heard? | 4 | 5 | 4 | 5 | 4 | 5 | 5 | 3 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5
10 | Were the presentations easily seen? | 4 | 5 | 4 | 5 | 5 | 3 | 5 | 3 | 4 | 5 | 5 | 3 | 5 | 5 | 4 | 5
11 | Do you feel meeting attendees had an opportunity to participate? | 3 | 4 | 5 | 5 | 5 | 5 | 3 | 3 | 2 | 4 | 5 | 3 | 5 | 4 | 4 | 5
12 | How useful did you find the meeting? | 3 | 5 | 3 | 4 | 5 | 4 | 3 | 3 | 4 | 3 | 5 | 3 | 5 | 5 | 4 | 3
13 | How enjoyable was the meeting? | 3 | 4 | 3 | 4 | 4 | 1 | 2 | 2 | 2 | 2 | 5 | 2 | 3 | 5 | 3 | 2
Spreadsheet: 859854d1708085735-regarding-automation-in-excel-tryin
Sheet: Sheet1

Days | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Sensor count | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500