tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738496d1625067452-formulae-to-locate-last-entry-from-two-columns-based-on-a-value-from-a-third-column-for-execl-forum
Sheet: Sample

Company | Name | Helper to find last row in related record | *Helper Ref | Source | Control Status | Delta Line (Actual) |  | Delta Line (History) | To Change? | Failed formulae | EXPECTED RESULTS | My Failed formulaes
Lateral4 | Carting |  | 725823 | Holland Brokers | Active |  |  | Judge [NAME] |  |  | Judge [NAME]
Lateral | List resign |  | 4534425 | Holland Brokers | Active | [NAME] |  | Alison Hartly
Lateral | List resign |  | 4534425 | Holland Brokers | Active | Shaun Davies |  | [NAME]
Lateral | List resign |  | 4534425 | Holland Brokers | Active | Morgan Freeman
Lateral | List resign |  | 4534425 | Holland Brokers | Active
Product 2 | Halo |  | 8384438 | Synology | Active
Product 2 | Halo |  | 8384438 | Synology | Active
Product 2 | Halo |  | 8384438 | Synology | Active
Product 2 | Halo |  | 8384438 | Synology | Active
Product 2 | Halo |  | 8384438 | Synology | Active
[NAME] | Rime |  | 72727 | Cart | Active
Jimson | Canibal |  | 44444 | Hasin | Active | [NAME] |  | [NAME]
Jimson | Canibal |  | 44444 | Hasin | Active | [NAME]
Jimson | Canibal |  | 44444 | Hasin | Active |  |  | [NAME]
Jimson | Canibal |  | 44444 | Hasin | Active |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | If there is a name in this column (column I) and no name in colum G (same row)  then I need to record the name that is shown in colum I in Colum K.    If there is a name in colum I and a name (same row or the next row down) in colum G then no name gets recorded in colum K  In a nutshell if the value in colum I is in the latest row for this record and there is no corresponding entry in column  G (same row)  then this needs to be captured in colum K |  | Cell K2 - Correct K2 is the latest name for this record and there is no entry on G2 so Judge [NAME] needs to be put in cell K2  Cell K6  - Wrong - As although there is an entry in I4, there is a corresponding entry in G4 and G5 that means that the history was supersceded with an actual change so this cell (k6) shoud be blank.  Even if G5 was blank k6 should be blank because there is an entry in G4  Cell K11 - This should be blank as there are no entries in column I.  You will note thAT IT PULLS THE LAST VALUE FOUND IN "I" from I4.  It should only pull the last value belonging to this record i.e rows 7-11.  Cell K12 - Incorrect - There is no entry in I so nothing to update  Cell K16 - This is correct as this is the latest value in colums I and G for the "Jimson" record see colum A i.e. [NAME] was superceeded by [NAME] and [NAME] was superceded by Don Fickle and this was superceded by [NAME]
Spreadsheet: 218479d1362480045-sumif-help-please-sumif
Sheet: Sheet1

2013-05-01 00:00:00 | 2013-05-05 00:00:00 | 2013-06-06 00:00:00 | 2013-06-08 00:00:00
[NAME] | [NAME] | [NAME] | [NAME]
100 | 200 | 300 | 300
 | [NAME] | [NAME] | [NAME]
May
June
Spreadsheet: 0dc9cf02-be0b-44c3-bce9-fe2ef3ae4be5
Sheet: ID-CPA-014

 |  | Prescribed Grazing  - 528 |  |  |  |  |  |  |  |  | ID-CPA-014
 |  | Proper Grazing Use |  |  |  |  |  |  |  |  | Idaho
Natural Resources Conservation Service |  |  |  |  |  |  |  |  |  |  | January 2014
Grazing Unit | Acres | Species of Grazing Animal | Season  of Use | Location of Key Grazing Area | Key Species for Judging Proper Grazing Use | Percent Use or Stubble Height of Key Species at End of Grazing Period | Estimated Use or Stubble Height of Key Species
 |  |  |  |  |  |  | 2014 | 2015 | 2016 | 2017 | 2018
 |  |  |  |  |  | Initials of Conservationist Assisting with Application:
 |  |  |  |  |  | Dates of Application Checks:
Client: |  |  |  |  |  | Date:
Conservationist: |  |  |  |  |  | Date:
Spreadsheet: afbe1d47-6600-4c0a-b623-8c8a05318bea
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
FASP | Test | FASP | Aspergillus Antibodies, Immunodiffusion | Aspergillus Antibodies, ID  (Serum) | Immunodiffusion (ID) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain red-top tube(s), serum gel tube is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Aspergillus flavus Ab Aspergillus niger Ab Aspergillus fumigatus Ab  Reference Range: Negative  Interpretive Criteria: 	Negative: Antibody not detected 	Positive: Antibody detected  A positive result is represented by 1 or more precipitin bands, and may indicate fungus ball, allergic bronchopulmonary aspergillosis (ABA) or invasive aspergillosis. Generally, the appearance of 3 - 4 bands indicates either fungus ball or ABA.  Test Performed by:	Focus Diagnostics, Inc. 			5785 Corporate Avenue 			Cypress, CA 90630-4750 | Monday through Friday | 2 - 5 days | 4 - 9 days | 3 | 86606 |  |  |  |  | Focus Diagnositics, Inc.
FASP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FASP | Result | [NAME] | Aspergillus flavus Ab | Aspergillus flavus Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FASP | Result | Z0518 | Aspergillus niger [NAME] | Aspergillus niger [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FASP | Result | Z0519 | Aspergillus fumigatus Ab | Aspergillus fumigatus Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 58f87005-2f36-43e1-a995-019f102d9f15
Sheet: 10's

10 UNDER
TEAM | Championships | Tourny's | Overall | Overall | Overall |  | Bracket | Bracket
2012-05-13 00:00:00 | Won | played | Win | Loss | Ties |  | Won | Lost
Florida Gold | 1 | 1 | 4 | 1 |  |  | 2 | 0
Florida Red Rage |  | 1 | 4 | 1 |  |  | 1 | 1
Lady Angels |  | 1 | 1 | 3 |  |  | 0 | 1
Plant City Black Widows |  | 1 | 0 | 4 |  |  | 0 | 1
[NAME] 10U |  | 1 | 0 | 4
[NAME] | 1 | 1 | 4 | 0
Spreadsheet: 65605d1266325529-filter-data-nested-search-ttttttt
Sheet: Motor Calcs (Generic)

 |  |  |  |  | 3 Ph Motor
 |  |  |  | Supply Voltage | 400 | V
 |  |  |  | Starter Type | DOL |  |  | 1 Ph Motor
 | No. Motor Poles | 4 |  | CPD | BS88 |  | Voltage | 230 | V
 | Motor Speed | 1500 | rpm | Motor Power | 1 | KW | Power | 0.25 | KW
 |  |  |  | FL Current |  | A | Current |  | A
 |  | Optional Motor Data |  | Power Factor | 0.85 |  | Power Factor | 0.9 | Manually Entered
 | Mass for Fly Wheel |  | Kg | Motor Efficiency | 83 | % | Motor Efficiency | 1 | Manually Entered
 | Outer Radius |  | m | Apparent Power | 1.176470588235294 | KVA | Apparent Power | 0.2777777777777778 | KVA
 | [NAME] |  | m | Motor Torque | 6.366666666666666 | Nm | Current = | 1.207729468599034 | Amps
 | Moment of Inertia | 0 | Kgm2 | CPD Rating (ln) | 6 | A
 |  |  |  | FL Current | 2.045890394010013 | Amps
 |  | Pump Data
 | Flow | 30 | l/s
 | Head | 12 | m
 | Pump Effy | 75 | %
 | Motor Effy | 85 | %
 | Power at Shaft | 4.707192 | KW
 | Power at Motor | 5.537872941176471 | KW
 |  |  |  |  | Cable Sizing Wizard (Calculated in accordance with BS7671:2008)
 |  |  |  |  |  |  |  | Results
 |  |  |  |  |  |  | Cable Size |  | mm2
 |  |  |  | Supply Voltage | 400 | V | Cable Makeup
 |  |  |  | Design Current Ib | 100 | A | Cable Rating (lt) |  | A
 |  |  |  |  |  |  | Min. Cable Capacity (lz) |  | A
 |  |  |  | Type of Cable | Single-core 70°C thermoplastic non-arm Cu Table 4D1 |  | Sep. [NAME] |  | mm2
 |  |  |  | Instalation Method Selection (Step 1) | Cable tray, ladder system, cleats, wire mesh tray |  | Device (ln/lr) |  | A
 |  |  |  | Instalation Method Selection (Step 2) | 31 - On horizontal/vertical perforated tray |  | Voltage Drop |  | V
 |  |  |  | Configuration | Flat touching |  | [NAME] for Voltage Drop |  | m
 |  |  |  |  |  |  | Zs at Load End |  | Ω
 |  |  |  | Neutral Conductor Sizing Method |  |  | [NAME] |  | Ω
 |  |  |  |  |  |  | Earth Fault Current |  | KA
 |  |  |  |  |  |  | Earth Fault Discon. Time |  | s
 |  |  |  |  |  |  | Min. Phase Fault Current |  | KA
 |  |  |  |  |  |  | PSCC |  | KA
 |  |  |  | Length of cable | 100 | m | Icu |  | KA
 |  |  |  | Permissible Volt Drop | 30 | %
 |  |  |  | [NAME] | 12 | mV/a/m
 |  |  |  | Single or [NAME] | Single
 |  |  |  | CPD type | BS88
 |  |  |  | CPD Rating (In) | 40 | A
 |  |  |  | Ambient/ground temperature rating factor (Ca) | 1 | Tables 4B1 - 4B2
 |  |  |  | Thermal insulation rating factor ([NAME]) | 0.8
 |  |  |  | CPD/installation condition rating factor (Cc) | 0.725
Spreadsheet: 85383d1285431717-count-this-and-that-copy-of-sample-for-help
Sheet: Sheet1

 | Supporting which job > | Inventory | Cashier | Inventory | Cashier | Cashier | Cashier | Inventory
 | TASKS | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Mark
 | Task 1 |  |  |  |  | 3 | 4 | 0
 | Task 2 | 2 |  | 1 |  | 3 | 2 | 4
 | Task 3 | 3 |  | 2 |  | 3 | 2 | 4
 | Task 4 | 3 |  | 2 |  | 3 | 3
 | Task 5 | 3 | 1 | 2
 | Task 6 | 2* | 1 |  |  |  |  | 3
 | Task 7
 | Task 8 | 2 |  |  | 1 | 1 |  | 2
 | Task 9 | 4 |  | 4 |  | 1 | 4
 | Task 10 |  |  |  |  | 2 | 3
 | Looking for a way to count if row 8 = cashier  and if so, sum the total number 1's, 2's, 3's and 4's
 | I am looking for this type of output:
 |  | Exp Lvl 1 | Exp Lvl 2 | Exp Lvl 3 | Exp Lvl 4
 | Cashier | 5 | 3 | 6 | 2
 | Inventory | 1 | 4 | 1 | 3
Spreadsheet: 155799d1337055439-extracting-multiple-values-vertically-with-input-in-one-cell-problem-statement
Sheet: Sheet1

Case |  |  |  |  |  | Outcome that I want
Name of Company | Director |  |  |  |  | Name of Company | Director
Company A | Mr. 1 |  |  | Input Cell |  | Company A | Mr. 1
Company A | Mr. [NAME] |  |  |  |  |  | Mr. [NAME]
Company B | Mr. [NAME] |  |  |  |  |  | Mr. 3
Company A | Mr. 3 |  |  |  |  |  | Mr. [NAME]
Company C | Mr. 9 |  |  |  |  |  | Mr. 5
Company A | Mr. 5
Company B | Mr. 5
Company B | Mr. [NAME]
Company B | Mr. [NAME]
Company A | Mr. [NAME]
Company C | Mr. 1
Company B | Mr. [NAME]
Company C | Mr. [NAME]
Company C | Mr. 5
Company C | Mr. [NAME]
Spreadsheet: 477610d1472406150-sum-if-sum-if-dummy-
Sheet: Sheet1

 | [NAME] |  |  |  |  | 300 |  | 400
 | [NAME] |  |  |  |  | 350 |  | 400
 | [NAME] |  |  |  |  | 200 |  | 275
 | [NAME] |  |  |  |  | 100 |  | 120
 | [NAME] |  |  |  |  | 150 |  | 175
 | Alejandro Marin |  |  |  |  | 175 |  | 375
 | Alejandro Moreda |  |  |  |  | 1000 |  | 1400
 | [NAME] |  |  |  |  | 75 |  | 375
 | [NAME] |  |  |  |  | 500 |  | 700
 | [NAME] |  |  |  |  | 565 |  | 615
Spreadsheet: 775146d1648840642-revenue-by-year-and-quarter-revenue-example
Sheet: Pivot Table

Years | Qtr | Sum of FIXED FEES TOTAL
2022 | Qtr1 | 0
 | Qtr2 | 1500000
 | Qtr3 | 2400000
 | Qtr4 | 0
2022 Total |  | 3900000
2023 | Qtr1 | 0
 | Qtr2 | 0
 | Qtr3 | 1200000
2023 Total |  | 1200000
2024 | Qtr1 | 0
 | Qtr2 | 0
 | Qtr3 | 900000
2024 Total |  | 900000
Grand Total |  | 6000000
Spreadsheet: 877280d1724069948-how-to-get-copy-paste-date-wise-horizontal-employee-attendance-vertically-attendance_horizontal-to-vertical-1-
Sheet: Sheet1

 |  | - | - | Week-1 | Week-1 | Week-1 | Week-1 | Week-1 | Week-2 | Week-2 | Week-2 | Week-2 | Week-2 | Week-3 | Week-3 | Week-3 | Week-3 | Week-3 | Week-4 | Week-4 | Week-4 | Week-4 | Week-4 | Week-4 | Week-5 | Week-5
 |  | - | - | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed
Sr No | Employee ID | Employee Name | [NAME] | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-08 00:00:00 | 2024-07-09 00:00:00 | 2024-07-10 00:00:00 | 2024-07-11 00:00:00 | 2024-07-12 00:00:00 | 2024-07-15 00:00:00 | 2024-07-16 00:00:00 | 2024-07-17 00:00:00 | 2024-07-18 00:00:00 | 2024-07-19 00:00:00 | 2024-07-22 00:00:00 | 2024-07-23 00:00:00 | 2024-07-24 00:00:00 | 2024-07-25 00:00:00 | 2024-07-26 00:00:00 | 2024-07-29 00:00:00 | 2024-07-30 00:00:00 | 2024-07-31 00:00:00
1 | 66852 | [NAME] | Domnik | P | P | PNS | P | P | PNS | P | P | PNS | P | P | P | P | P | P | P | P | P | P | P | P | P | P
2 | 83288 | Stella | Maria | P | PNS | P | P | P | P | P | P | P | P | P | P | PNS | P | PL | P | UL | PL | P | P | P | P | P
3 | 23176 | [NAME] | [NAME] | PL | P | P | PL | PL | P | NCNS | PL | PL | PL | P | P | P | P | P | P | P | P | P | P | PL | P | P
4 | 20723 | [NAME] | Nick | P | UL | PNS | P | P | UL | P | P | P | P | PL | PL | PNS | P | P | P | P | P | UL | P | P | P | P
5 | 36517 | [NAME] | Kathy | PNS | P | P | P | PL | P | PNS | P | P | P | P | P | P | P | P | PL | P | UL | P | P | P | P | UL
6 | 82021 | [NAME] | [NAME] | P | P | P | PL | P | P | P | P | P | P | P | PNS | P | P | P | P | P | P | P | PL | P | P | P
Sr No | Employee ID | Employee Name | [NAME] | Date | Attendance
1 | 66852 | [NAME] | Domnik | 2024-07-01 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-02 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-03 00:00:00 | PNS
 | 66852 | [NAME] | Domnik | 2024-07-04 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-05 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-08 00:00:00 | PNS
 | 66852 | [NAME] | Domnik | 2024-07-09 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-10 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-11 00:00:00 | PNS
 | 66852 | [NAME] | Domnik | 2024-07-12 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-15 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-16 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-17 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-18 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-19 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-22 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-23 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-24 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-25 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-26 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-29 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-30 00:00:00 | P
 | 66852 | [NAME] | Domnik | 2024-07-31 00:00:00 | P
Spreadsheet: 704314d1605494311-data-rearrangement-in-row-book3
Sheet: Sheet1

 |  |  | 1 | 4 | 7 | 10 | 13 | 16 | 19 | 22 | 25 | 28 | 31
 |  |  | 2 | 5 | 8 | 11 | 14 | 17 | 20 | 23 | 26 | 29 | 32
 |  |  | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33
 |  |  |  |  |  |  |  | 6 |  |  |  | ? | ? | ?
Spreadsheet: 885345d1734852120-date-format-not-working-datedif-spreadsheet
Sheet: Sheet1

Acquired | Term | $ Total Gain/Loss | % Total Gain/Loss | Current Value | Quantity | Average Cost Basis | Cost Basis Total | ROI | Value | [NAME]
Dec-18-2024 | Short | 8640 | 0.1202 | 80550 | 1000 | 71.91 | 71910 |  | 2024-12-20 00:00:00 | 3
Dec-09-2024 | Short | 8795 | 0.1226 | 80550 | 1000 | 71.75 | 71755 |  | 2024-12-20 00:00:00 | 12
Dec-09-2024 | Short | 887.5 | 0.0461 | 20137.5 | 250 | 77 | 19250 |  | 2024-12-20 00:00:00 | 12
Nov-29-2024 | Short | 20625.3 | 0.2058 | 120825 | 1500 | 66.8 | 100199.7 |  | 2024-12-20 00:00:00 | 22
Spreadsheet: 805373d1668641043-a-woodworker-in-need-of-help-with-if-function-with-sum-as-a-condition-new-template-2022-v2-etaf-v2
Sheet: Test Template

Material Cost
 |  | Price per unit |  |  |  |  |  |  | Primary Wood | Nogal USA
 |  |  |  |  |  |  |  |  | Secondary Wood | [NAME]
 |  |  |  |  |  |  |  | Final Dimensions
Drawer runners | 3 | 18
Tooling | 1 | 35 |  |  |  |  |  | Wood | Element | Quantity | Length |  | [NAME] | Thickness | m2
 |  | Total |  |  |  |  |  | 1st | Top/Bottom | 1 | 1 |  | 1.4 | 0.045
Labor Cost |  |  |  |  |  |  |  | 1st | Walls | 2 | 0.8 |  | 0.8 | 0.03
Time |  | Price per minute |  |  |  |  |  | 1st | Back | 1 | 3 |  | 0.8 | 0.01
Processing |  | 5 |  |  |  |  |  | 1st | Legs | 4 | 0.5 |  | 0.05 | 0.05
Cutting All pieces | 3 | 40 |  |  |  |  |  | 2nd | Sttrecther | 2 | 2.8 |  | 0.1 | 0.05
Drawers | 6 | 40 |  |  |  |  |  | 1st | Rails | 2 | 0.8 |  | 0.05 | 0.05
Glue up | 6 | 30 |  |  |  |  |  | 1st | Seperations | 2 | 0.8 |  | 0.8 | 0.02
Sanding | 5 | 30 |  |  |  |  |  | 1st | Doors | 3 | 1 |  | 0.8 | 0.02
Finish | 10 | 20
Assemply and cutting joints | 4 | 40
Delivery | 0 | 350 |  |  | RAW LUMBER
Stacking | 0 | 100
 |  | Total |  |  |  |  |  |  | length | thickness | width | [NAME] | quantity | m2 | m3 | Price/m3 | Price | [NAME]
Shop Costs |  | 14 |  |  |  |  |  |  | 3.6 |  | 0.18 | 0.16
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Construction Total |  |  |  |  |  |  | 3.6 |  | 0.18
 |  | Profit |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  |  | 0
 |  | Total |  |  |  |  |  |  | 3.6 |  | 0.18 |  |  |  |  | 0
 |  | IVA |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | 3.6 |  | 0.18
 |  |  |  |  |  |  |  |  | ETAF - CALC
 |  |  |  |  |  |  |  |  | Widths needed
Spreadsheet: 108537d1305594961-help-on-stopping-cells-from-changing-copy-of-copy-of-copy-of-copy-of-allowances
Sheet: Workings

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowance Changes
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Withdrawals |  |  |  | Deposits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deposits |  |  | 2011-05-01 00:00:00 | 3 | 3
 |  |  | 0.3 |  | 0.2 |  | 0.5 |  | 0.1 |  | 0.1 |  |  |  |  | Long Term Savings | Savings | Charity | Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Long Term Savings | Savings | Charity | Holiday |  |  |  | 2011-05-12 00:00:00 | 4.5 | 4
 | Amount Paid | Allowance + Deposit | Long Term Savings | [NAME] | Interest Earned | Long Term Total | Savings | Savings Balance | Charity | Charity Balance | Holiday Savings | Holiday Balance | Total Balance |  |  |  |  |  |  |  |  | Amount Paid | Allowance + Deposit | Long Term Savings | [NAME] | Interest Earned | Long Term Total | Savings | Savings Balance | Charity | Charity Balance | Holiday Savings | Holiday Balance | Total Balance
2011-05-06 00:00:00
2011-05-13 00:00:00
2011-05-20 00:00:00
2011-05-27 00:00:00
2011-06-03 00:00:00
2011-06-10 00:00:00
2011-06-17 00:00:00
2011-06-24 00:00:00
2011-07-01 00:00:00
2011-07-08 00:00:00
2011-07-15 00:00:00
2011-07-22 00:00:00
2011-07-29 00:00:00
2011-08-05 00:00:00
2011-08-12 00:00:00
2011-08-19 00:00:00
2011-08-26 00:00:00
2011-09-02 00:00:00
2011-09-09 00:00:00
2011-09-16 00:00:00
2011-09-23 00:00:00
2011-09-30 00:00:00
2011-10-07 00:00:00
2011-10-14 00:00:00
2011-10-21 00:00:00
2011-10-28 00:00:00
2011-11-04 00:00:00
2011-11-11 00:00:00
2011-11-18 00:00:00
2011-11-25 00:00:00
2011-12-02 00:00:00
2011-12-09 00:00:00
2011-12-16 00:00:00
2011-12-23 00:00:00
2011-12-30 00:00:00
Spreadsheet: kate_symes__18159__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 244.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
Spreadsheet: 87807d1287669035-assigning-specific-values-to-strings-and-or-numbers-qa-1-1-
Sheet: Sheet1

 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Julie | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Julie | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | Julie | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nearest |  |  |  |  |  |  |  |  | Min
 | Question | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Score | Score | Score | Score | Score | Score | Score
1 | What is 75+2? | 77 | 99 | 75 | 88 | 77 | 21 | 80 | 78 | 0 | 0 | 0 | 2 | 0 | 0 | 0 |  | 22 | 2 | 11 | 0 | 56 | 3 | 1 |  | 0
2 | What is the capital of England? | London | Prague | London | Lisbon | Madrid | London | Cardiff | Edinburgh | 0 | 2 | 0 | 0 | 2 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
3 | How many letters in the word "Sink"? | 4 | 4 | 6 | 5 | 2 | 4 | 1 | 8 | 2 | 0 | 0 | 0 | 2 | 0 | 0 |  | 0 | 2 | 1 | 2 | 0 | 3 | 4 |  | 0
4 | What is the tallest mountain in the world? | Everest | Everest | [NAME] | [NAME] | Everest | Everest | Matterhorn | Everest | 2 | 0 | 0 | 2 | 2 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
5 | What is 2+2 | 4 | 22 | 1 | 5 | 6 | 7 | 4 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 0 |  | 18 | 3 | 1 | 2 | 3 | 0 | 1 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No-one has answered correctly but two people are the closest (Jim & Barbara) so they would each get 1 point
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 people have answered correctly (Jim & Julie) so they would get 2 points each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 people have answered correctly (John & Julie) so they would get 2 points each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 people have answered correctly ([NAME], [NAME] and [NAME]) so they would get 2 points each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Only one person has answered correctly ([NAME]) so she would get 2 points