tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57577d1257790483-calculation-according-to-date-book1
Sheet: Sheet1

 |  |  |  |  | Financial
Raw Data |  |  |  |  |  |  |  | Compile
Date | Name | Agent ID | Mistake Type |  |  | Agent Name | Agent ID | 2009-11-01 00:00:00 | 2009-11-02 00:00:00 | 2009-11-03 00:00:00 | 2009-11-04 00:00:00 | 2009-11-05 00:00:00 | 2009-11-06 00:00:00 | 2009-11-07 00:00:00 | 2009-11-08 00:00:00 | 2009-11-09 00:00:00 | 2009-11-10 00:00:00 | 2009-11-11 00:00:00 | 2009-11-12 00:00:00 | 2009-11-13 00:00:00 | 2009-11-14 00:00:00
2009-11-01 00:00:00 | Example1 | 2270 | Financial |  |  | Example1 | 2270 | 6
2009-11-02 00:00:00 | Example2 | 2271 | Non Financial |  |  | Example2 | 2271
2009-11-03 00:00:00 | Example3 | 2272 | Non Financial |  |  | Example3 | 2272
2009-11-04 00:00:00 | Example4 | 2273 | Non Financial |  |  | Example4 | 2273
2009-11-05 00:00:00 | Example5 | 2274 | Non Financial |  |  | Example5 | 2274
2009-11-01 00:00:00 | Example1 | 2270 | Financial |  |  | Example6 | 2275
2009-11-07 00:00:00 | Example7 | 2276 | Financial |  |  | Example7 | 2276
2009-11-08 00:00:00 | Example8 | 2277 | Non Financial |  |  | Example8 | 2277
2009-11-09 00:00:00 | Example9 | 2278 | Financial |  |  | Example9 | 2278
2009-11-10 00:00:00 | Example10 | 2279 | Non Financial |  |  | Example10 | 2279
2009-11-11 00:00:00 | Example11 | 2280 | Financial |  |  | Example11 | 2280
2009-11-12 00:00:00 | Example12 | 2281 | Non Financial |  |  | Example12 | 2281
2009-11-13 00:00:00 | Example13 | 2282 | Financial |  |  | Example13 | 2282
2009-11-14 00:00:00 | Example14 | 2283 | Non Financial |  |  | Example14 | 2283
Spreadsheet: 274773d1383216727-cutting-list-and-composite-decking-calculator-composite-decking-cutting-calc
Sheet: CUTTING LIST REQ'D

 | CUTTING LIST |  |  |  | CALCULATOR
 | EDGING BOARD  (Bevelled edge no groove) |  |  |  | BOARD
 | QTY REQ'D | LINEAR MTR | TOTAL LM
 | 4 | 0.5 |  |  | 4.88
 | 2 | 0.6 |  |  | 4.88
 | 2 | 0.7
 | 4 | 0.8
 | 3 | 1.1
 | 2 | 1.4
 | 1 | 1.8
 | 2 | 2.1
 | 2 | 2.4
 | 2 | 2.7
 | 1 | 3
 | GROOVED EDGE BOARD
 | QTY REQ'D | LINEAR MTR | TOTAL LM
 | 5 | 2.1
 | 5 | 1.8
 | 8 | 0.5
 | 4 | 0.6
 | 4 | 0.7
 | 8 | 0.8
 | 6 | 1.1
 | 4 | 1.4
 | 2 | 1.8
 | 4 | 2.1
 | 4 | 2.4
 | 4 | 2.7
 | 2 | 3
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 10

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 10:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
109 | January
110 | February
111 | March
112 | April
113 | May
114 | June
115 | July
116 | August
117 | September
118 | October
119 | November
120 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 106616d1303843708-multiple-cell-drop-down-list-example-pricing-system
Sheet: Pricing Worksheet

Custom Cabinet Pricing System
Customer: |  |  | Quote date - | 2011-04-26 00:00:00
Job:
[NAME]: |  |  | Phone # -
Room: |  |  | Fax # -
Quantity | Item Code | Item Description | List Price | Total List
 |  |  |  |  |  | Double Click on a cell in column B
 |  |  |  | 0 |  | Begin Typing an Item Code
 |  |  |  | 0 |  | Use the Up/Down Arrow Keys to [NAME]
 |  |  |  | 0 |  | Use the TAB or ENTER key to exit the ComboBox
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  | Shipping |  | 0
 |  |  | Subtotal | 0
Door Style |  |  |  | 0
Wood Species |  |  |  | 0
 | Finish |  |  | 0
Special Finish |  |  |  | 0
 |  |  | Subtotal | 0
 |  |  | Net | 0
 |  |  | Margin | 0.33
 |  |  | Retail Total | 0
Spreadsheet: 810792d1672073981-formula-to-determine-how-to-best-fit-a-series-of-number-inside-another-test-2
Sheet: Sheet1

 |  |  |  |  |  | 124
 | part length | part count | quotient | fit check | remaing length avail |  |  |  | min
 | 12
 | 7
 | 3
 | 2
 |  |  |  |  |  | works with whole numbers
 |  |  |  |  |  | does not work with first item at 11.5 and 116 length
Spreadsheet: 5d470d96-4007-4b65-98cf-29117ff92095
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-04-03 09:26:07.810000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.452 | 102.327 | 102.202 | 101.827
4.625 | 101.691 | 101.566 | 101.441 | 101.066 |  | Note: | Refer To Price [NAME]
4.5 | 100.753 | 100.628 | 100.503 | 100.128 |  |  | For all Price Adjs
4.375 | 99.802 | 99.677 | 99.552 | 98.927
4.25 | 99.224 | 99.099 | 98.974 | 98.349
4.125 | 98.393 | 98.268 | 98.143 | 97.518
4 | 97.375 | 97.25 | 97.125 | 96.5
3.875 | 96.326 | 96.201 | 96.076 | 95.451
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.822 | 102.697 | 102.572 | 102.197
3.875 | 102.09 | 101.965 | 101.84 | 101.465
3.75 | 101.644 | 101.519 | 101.394 | 101.019
3.625 | 101.204 | 101.079 | 100.954 | 100.579
3.5 | 100.654 | 100.529 | 100.404 | 99.779
3.375 | 99.859 | 99.734 | 99.609 | 98.984
3.25 | 99.081 | 98.956 | 98.831 | 98.206 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-17 09:26:07.810000
30 DAY | 2014-05-02 09:26:07.810000
45 DAY | 2014-05-17 09:26:07.810000
60 DAY | 2014-06-01 09:26:07.810000
90 DAY | 2014-07-01 09:26:07.810000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: kam_keiser__17983__Post ID '01 Enron Direct
Sheet: Nov01

ENRON DIRECT CANADIAN BOOK
POST IDS
Nov-1-01
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Ontario Deals |  |  |  |  |  |  |  | Enron Canada Corp. Deals |  |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS-Prop
 |  |  | FT-CAND-DIRECT | FT-CAND-DIRECT | FT-CAND-DIRECT | FT-CAND-DIRECT | FT-CAND-DIR-GD | FT-CAND-DIR-GD | FT-DIR-AGENCY | FT-DIR-AGENCY | FT-DIR-AGENCY | FT-DIR-AGENCY | FT-CAND-DIR-ONT | FT-CAND-DIR-ONT | FT-CAND-DIR-ONT | FT-CAND-DIR-ONT | FT-DIR-ONT-GD | FT-DIR-ONT-GD | FT-CAND-EGSC-ED | FT-CAND-EGSC-ED | FT-CAND-EGSC-ED | FT-CAND-EGSC-ED | INTRA-CAN-ED-GD | INTRA-CAN-ED-GD |  |  | [NAME] | [NAME] |  |  | CAD Options | CAD Options | CAD Options | CAD Options | USD Options | USD Options | Exotics | Gas Daily | Exotics
BOOK --> |  |  | C$ | $US | Index- C$ | Index- $US | Gas Daily-C$ | Gas Daily-$US | C$ | $US | Index- C$ | Index- $US | C$ | $US | Index- C$ | Index- $US | Gas Daily-C$ | Gas Daily-$US | $CAD | $US | Index | Index- $US | C$ | US$ |  |  | C$ | US$ | P7 | INDEX | C$ | US$ | C$ Index | US$ Index | C$ | US$ | C$ | CD$ | US$
MOVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M |  | M |  | M |  | M |  | M/E only
OFFICIALIZE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | O | O | O | O | O | O | O |  |  | officialize day
FTP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | after month end | Officialized
2001-11-30 00:00:00 | f | Liquidate | 1425361 | 1425362 | 1425363 | 1425364 | 1425365 | 1425366 | 1425367 | 1425368 | 1425369 | 1425370 | 1425371 | 1425372 | 1425373 | 1425374 | 1425375 | 1425378 | 1425379 | 1425405 | 1425406 | 1425407 | 1425408 | 1425409
Spreadsheet: 703698d1605116997-sum-combining-data-from-more-than-one-tables-book1
Sheet: Sheet1

POs
po id | date | customer |  | customer | item id | lookup | [NAME]
po1 | 2020-11-01 00:00:00 | cus-B |  | cus-A | it-1
po2 | 2020-11-02 00:00:00 | cus-A |  | cus-A | it-2
PO lines
po id | item id | quantity
po1 | it-1 | 2
po1 | it-2 | 5
po2 | it-1 | 20
Spreadsheet: 00d918fa-4f64-453d-b01d-86dbd8cd0e99
Sheet: SUMMARY - Year 5

BUDGET SUMMARY
CATEGORIES
I.       PERSONNEL SERVICES
II.      CONSULTANT  SERVICES
III.     SUBCONTRACT SERVICES
IV.     PATIENT SERVICES
[NAME]
VI.     SUPPLIES
VII.    TRAVEL
VIII.   OTHER COSTS
TOTAL
-26-
Spreadsheet: 17b32f8f-b51b-4b0c-8680-278b3857f115
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ausländer und Ausländerinnen, welche länger als 2 Jahre in der [NAME] bleiben möchten, werden verpflichtet, die Sprache des jeweiligen Landesteils zu lernen.
 | Zivilstand:
Antwort | Ledig | Verheiratet / Konkubinat / Eingetragene Partnerschaft | Geschieden | [NAME]
[NAME] | 0.88 | 0.89 | 0.91 | 0.89
Neutral / Weiss nicht | 0.06 | 0.06 | 0.06 | 0.04
[NAME] | 0.05 | 0.05 | 0.03 | 0.07
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 767471d1644492381-vlookup-in-time-schedule-no-data-in-tables-for-a-specific-day-school-traffic
Sheet: Data

Name | Surename | Street | door number | City | School | class | school end moday | school end Tuesday | school end wendsday | school end Thursday | Schoolend Friday
Müller | [NAME] | St.[NAME] | 5 | Waldburg | Marianum |  | 12:40:00 | 11:45:00 | 15:30:00 | 12:40:00 | 15:30:00
Müller | Nico | St.[NAME] | 5 | Waldburg | VS 1 |  | 15:30:00 | 15:30:00 | 12:40:00 | 13:35:00 | 13:35:00
Bauer | Bernd | [NAME] | 5 | Freistadt | VS 1 |  | 11:45:00 | 13:35:00 | 15:30:00 | 13:35:00 | 12:40:00
Haider | Nico | [NAME] | 6a | Freistadt | VS 2 |  | 15:30:00 | 16:15:00 | 16:15:00 | 16:15:00 | 11:45:00
Haider | Florian | [NAME] | 6a | Freistadt | VS 1 |  | 12:40:00 | 11:45:00 | 12:40:00 | 12:40:00 | 13:35:00
Horner | Laurenz | [NAME] | 22 | Neumarkt | Gym |  | 16:15:00 | 12:40:00 | 13:35:00 | 16:15:00 | 16:15:00
Horner | Helena | [NAME] | 22 | Neumarkt | Gym |  | 13:35:00 | 11:45:00 | 15:30:00 | 15:30:00 | 15:30:00
Horner | [NAME] | [NAME] | 22 | Neumarkt | VS1 |  | 12:40:00 | 13:35:00 | 12:40:00 | 11:45:00 | 12:40:00
Madl | Lukas | Lest | 32 | Rainbach i.Mkr | HAK |  | 16:15:00 | 15:30:00 | 12:40:00 | 15:30:00 | 11:45:00
Madl | Florian | Lest | 32 | Rainbach i.Mkr | Hauptschule |  | 15:30:00 | 15:30:00 | 15:30:00 | 13:35:00 | 12:40:00
Spreadsheet: 853343d1703216374-rota-return-data-based-on-3-criteria-from-table-rota-bvj-
Sheet: Rota

Name | Duty | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00 | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00
[NAME] | 05:00:00 |  |  | R | R | R | R
Fred | 05:00:00 | R |  |  |  |  |  | R
[NAME] | 07:00:00 | r | r | r
[NAME] | 08:00:00 |  |  |  | R | R | R | R
[NAME] | 08:00:00 | R | R | R | R
[NAME] | 10:00:00 |  |  |  |  | r | r | r
Marge | 10:00:00 | r | r | r | r
 | week num►
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 14 Feb 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-02-14 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | Annual | Annual | EFS | Annual
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 57021d1257199646-excel-2007-exclude-negative-number-book1-2
Sheet: Sheet1

2424 | 0.38 |  | 45 | 0.36
2664 | 0.38 |  | 65 | 0.29
322 | 0.38 |  | 10 | 0.34
1441 |  |  | 35 | 0.32
2231 |  |  | 37 | 0.37
1882 |  |  | 34 | 0.37
 |  |  |  |  | I would like this to not calculate with a negative, if E9 is less than 40, I want the cell to report zero.
Spreadsheet: 885113d1734536626-changing-multiplier-based-on-cell-value-lillebergen-points-form-spill-365-aligw
Sheet: January

Date | Attended | Points |  | Date | Attended | Points
1
2 |  |  |  | 2025-01-02 00:00:00
3 | 1 |  |  | 2025-01-03 00:00:00
4 |  |  |  | 2025-01-04 00:00:00 | 1 | 4
5 |  |  |  | 2025-01-05 00:00:00
6 |  |  |  | 2025-01-06 00:00:00
7 | 1 |  |  | 2025-01-07 00:00:00
8 | 1 |  |  | 2025-01-08 00:00:00 | 1
9 |  |  |  | 2025-01-09 00:00:00 | 1
10 |  |  |  | 2025-01-10 00:00:00
11 | 1 |  |  | 2025-01-11 00:00:00
12 |  |  |  | 2025-01-12 00:00:00 | 1 | 6
13 |  |  |  | 2025-01-13 00:00:00
14 | 1 |  |  | 2025-01-14 00:00:00
15 |  |  |  | 2025-01-15 00:00:00 | 1
16 |  |  |  | 2025-01-16 00:00:00
17 | 1 |  |  | 2025-01-17 00:00:00
18 |  |  |  | 2025-01-18 00:00:00 | 1 | 4
19 |  |  |  | 2025-01-19 00:00:00
20 |  |  |  | 2025-01-20 00:00:00
21 | 1 |  |  | 2025-01-21 00:00:00
22 |  |  |  | 2025-01-22 00:00:00 | 1
23 |  |  |  | 2025-01-23 00:00:00
24 |  |  |  | 2025-01-24 00:00:00
25 | 1 |  |  | 2025-01-25 00:00:00
26 |  |  |  | 2025-01-26 00:00:00 | 1 | 6
27 |  |  |  | 2025-01-27 00:00:00
28 |  |  |  | 2025-01-28 00:00:00
29 |  |  |  | 2025-01-29 00:00:00
Total |  |  |  | 2025-01-30 00:00:00
 |  |  |  | 2025-01-31 00:00:00
Spreadsheet: 838228d1690830275-dynamic-column-for-index-match-match-formula-index-match-match-example-tms
Sheet: Customer Codes Table

Customer | Codes | Description
 |  |  |  | Customers | Codes | Description
Customer 1 | 5011 | General [NAME] |  |  |  | General [NAME]
Customer 1 | 5012 | [NAME] |  | Customer 2 | 5012 | [NAME]
Customer 1 | 90077 | Working Foreman A |  | Customer 3 | 90077 | Working Foreman A
Customer 1 | 50003 | Working Foreman B |  | Customer 4 | 50003 | Working Foreman B
Customer 1 | 90009 | [NAME] |  | Customer 5 | 90009 | [NAME]
Customer 1 | 50130 | Climber A |  |  | 50130 | Climber A
Customer 1 | 50195 | Climber B |  |  | 50195 | Climber B
Customer 2 | LF | [NAME]
Customer 2 | CF | [NAME]
Customer 2 | CL | [NAME]Climber
Customer 2 | EO | Equipment Operator
Customer 2 | GM | [NAME]
Customer 3 | 4-Person Crew | 4-Person Crew
Customer 3 | 5-Person Crew | 5-Person Crew
Customer 3 | 6-Person Crew | 6-Person Crew
Customer 4 | 120747 | Flagger
Customer 4 | 700000-HR | Skilled Truck Operator
Customer 4 | 799070 | Laborer/Brushman
Customer 4 | 799090 | [NAME]/Trimmer
Customer 4 | 799095 | [NAME]
Customer 5 | 331 | Supervisor
Customer 5 | 332 | Contact Person
Customer 5 | 333 | Casual Labor
Customer 5 | 334 | Leader  A
Customer 5 | 335 | Leader B
Customer 5 | 336 | Journeyperson
Customer 5 | 337 | Apprentice B
Spreadsheet: f25024ef-cbe5-4ef8-8a11-f253fe3fd529
Sheet: Sheet1

created: 09 Thursday May 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
NO | NAMESPACE | VARIABLE | VALUE | LABEL
1 | L | URN | 125773 | Unique Reference Number
2 | L | LA | 937 | Local authority Number
3 | L | ESTAB | 6002 | School number
4 | L | LAESTAB | 9376002 | DfE Number
5 | L | SCHNAME | Bilton Grange School | School name
6 | L | STREET | Dunchurch | Street
7 | L | LOCALITY |  | Locality
8 | L | ADDRESS3 |  | Address
9 | L | TOWN | Rugby | Town
10 | L | POSTCODE | CV22 6QU | Postcode
11 | L | TELNUM | 01788 810217 | Telephone number
12 | L | ICLOSE | Open | Closed school
13 | L | OPENDATE |  | Date school opened since 12th September only
14 | L | CLOSEDATE |  | Date school closed since 12th September only
15 | L | ISNEW |  | New school
16 | L | MINORGROUP | Independent School | Type of school/college
17 | L | NFTYPE | Other Independent School | School type
18 | L | ISPRIMARY | 1 | Primary
19 | L | ISSECONDARY | 1 | Secondary
20 | L | ISPOST16 | 0 | 16-18
21 | L | AGEL | 3 | Lowest age of entry
22 | L | AGEH | 14 | Highest age of entry
23 | L | GENDER |  | Gender of entry
24 | L | SFGENDER | Mixed | Gender of entry to sixth form
25 | L | RELDENOM | Christian | Denomination
26 | L | ADMPOL | Not collected | Current admissions policy
27 | L | NEWACFLAG | 6 | Flag for Academy
28 | [NAME] | URN | 125773 | Unique Reference Number
29 | [NAME] | LA | 937
30 | [NAME] | ESTAB | 6002
31 | [NAME] | [NAME] | 307 | Total number of pupils on roll (all ages)
32 | [NAME] | NORG | 118 | Number of girls on roll
33 | [NAME] | NORB | 189 | Number of boys on roll
34 | [NAME] | PNORG | 0.384 | Percentage of girls on roll
35 | [NAME] | PNORB | 0.616 | Percentage of boys on roll
36 | [NAME] | TSENSAP | NP | Number of pupils SEN statement or on School Action Plus
37 | [NAME] | TSENA | NP | Number of pupils on roll with SEN on School Action
38 | [NAME] | PSENSAP | NP | Percentage of pupils with SEN statement or on School Action Plus
39 | [NAME] | PSENA | NP | Percentage of pupils on roll with SEN on School Action
40 | [NAME] | TOTPUPEALDN | NP | Number of pupils of compulsory school age and above
41 | [NAME] | NUMEAL | NP | Number of pupils with English not as first language
42 | [NAME] | NUMUNCFL | NP | Number of pupils where first language is unclassified
43 | [NAME] | PNUMEAL | NP | Percentage of pupils with English not as first language
44 | [NAME] | PNUMUNCFL | NP | % pupils where first language is unclassified
45 | [NAME] | TOTPUPFSMDN | NP | Number of pupils used in FSM calculation
46 | [NAME] | NUMFSM | NP | Total pupils eligible for free school meals
47 | [NAME] | PNUMFSM | NP | Percentage of  pupils eligible for free school meals
48 | [NAME] | NUMFSMEVER | NP | Number of pupils eligible for FSM at any time during the past 6 years
49 | [NAME] | PNUMFSMEVER | NP | Percentage of pupils eligible for FSM at any time during the past 6 years
Spreadsheet: 89089d1288862381-networkdays-formula-example
Sheet: Holidays

Date | Holiday
2009-01-01 00:00:00 | New Year's Day
2009-04-10 00:00:00 | Good Friday
2009-04-13 00:00:00 | Easter Monday
2009-05-04 00:00:00 | Early May BH
2009-05-25 00:00:00 | Spring BH
2009-08-31 00:00:00 | Summer BH
2009-12-25 00:00:00 | Christmas Day
2009-12-28 00:00:00 | Boxing Day
2010-01-01 00:00:00 | New Year's Day
2010-04-02 00:00:00 | Good Friday
2010-04-05 00:00:00 | Easter Monday
2010-05-03 00:00:00 | Early May BH
2010-05-31 00:00:00 | Spring BH
2010-08-30 00:00:00 | Summer BH
2010-12-27 00:00:00 | Christmas Day
2010-12-28 00:00:00 | Boxing Day
2011-01-03 00:00:00 | New Year's Day
2011-04-22 00:00:00 | Good Friday
2011-04-25 00:00:00 | Easter Monday
2011-05-02 00:00:00 | Early May BH
2011-05-30 00:00:00 | Spring BH
2011-08-29 00:00:00 | Summer BH
2011-12-26 00:00:00 | Christmas Day
2011-12-27 00:00:00 | Boxing Day
Spreadsheet: 230380d1366744897-return-multiple-values-from-multiple-sheets-example
Sheet: OVERVIEW

EQUIPMENT | DATE | TEMP | BEGIN PSIG | MCF LOSS
Spreadsheet: 723572d1615794850-how-to-calculate-of-slots-which-fit-into-open-capacity-example_task-capacity
Sheet: Sheet1

Additional tasks: | 6 | section to demonstrate where additional tasks fit |  |  |  |  |  | 1 | section to demonstrate where additional tasks fit |  |  |  |  |  | 2 | section to demonstrate where additional tasks fit
Time | Day 1 |  |  |  |  |  |  | Day 2 |  |  |  |  |  |  | Day 3
00:00:00 | -1 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3 | (1 continue)
00:30:00 | -2 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3
01:00:00 | 3 |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
01:30:00 | 0 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
02:00:00 | 5 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
02:30:00 | 8 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
03:00:00 | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
03:30:00 | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
04:00:00 | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
04:30:00 | 0 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
05:00:00 | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
05:30:00 | 10 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 10
06:00:00 | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
06:30:00 | -1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
07:00:00 | 3 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
07:30:00 | -1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
08:00:00 | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
08:30:00 | -1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
09:00:00 | 0 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
09:30:00 | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
10:00:00 | -3 |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
10:30:00 | -1 |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
11:00:00 | -7 |  |  |  |  |  |  | -4 |  |  |  |  |  |  | -4
11:30:00 | 3 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 | 2
12:00:00 | 0 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8
12:30:00 | -1 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 6
13:00:00 | 1 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 4
13:30:00 | 2 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 2
14:00:00 | 9 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 5
14:30:00 | 3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 2
15:00:00 | 6 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
15:30:00 | 4 |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
16:00:00 | 6 |  |  |  |  |  |  | -2 |  |  |  |  |  |  | -2
16:30:00 | 4 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
17:00:00 | 3 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3
17:30:00 | 2 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
18:00:00 | 11 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8
18:30:00 | 3 |  |  |  |  |  |  | -2 |  |  |  |  |  |  | -2
19:00:00 | 3 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
19:30:00 | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
20:00:00 | 4 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
20:30:00 | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
21:00:00 | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
21:30:00 | -1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
22:00:00 | 2 |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1
22:30:00 | 2 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
23:00:00 | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
23:30:00 | -1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
Spreadsheet: 108884d1305825874-call-top3-based-on-duplicate-data-and-ranking-info-sophyex-v4
Sheet: Sheet1

Make | Model | Rating |  | Rating | Ford | Chevy | Dodge
Ford | Bronco | 64 |  | 1
Chevy | Corvette | 94 |  | 2
Dodge | Intrepid | 83 |  | 3
Chevy | Chevette | 34
Dodge | Viper | 72
Ford | [NAME] | 21
Ford | Expedition | 53
Chevy | Impala | 67
Ford | Fairmont | 11
Dodge | Dart | 33