tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40205d1238518183-lookup-with-multiple-possible-returns-sample-order-count
Sheet: Sheet1

Trx # | Claim / Invoice # | Order # | Inv Date | Item # | Qty | Cost | Total
70524911 | 12097693 | 157425442 | 2008-12-08 00:00:00 | 95477 | 1 | 41.25 |  |  |  | Count
70524911 | 12097693 | 157425442 | 2008-12-08 00:00:00 | 95527 | -1 | 49.25
70525905 | 12097943 | 157422264 | 2008-12-08 00:00:00 | 95477 | 1 | 41.25
70525905 | 12097943 | 157422264 | 2008-12-08 00:00:00 | 95527 | -1 | 49.25
70525650 | 12098432 | 157419593 | 2008-12-08 00:00:00 | 95477 | 1 | 41.25
70525650 | 12098432 | 157419593 | 2008-12-08 00:00:00 | 95527 | -1 | 49.25
70522266 | 11718904 | 157077285 | 2008-10-28 00:00:00 | 83267 | 1 | 24.75
70522266 | 11718904 | 157077285 | 2008-10-28 00:00:00 | 93269 | -1 | 41.25
70516495 | 11982069 | 157123723 | 2008-11-18 00:00:00 | 75729 | 1 | 24.75
70516495 | 11982069 | 157123723 | 2008-11-18 00:00:00 | 75731 | -1 | 41.25
70516270 | 11982661 | 157143152 | 2008-11-18 00:00:00 | 75735 | -1 | 33
70516270 | 11982661 | 157143152 | 2008-11-18 00:00:00 | 75729 | 1 | 24.75
70516433 | 11983662 | 157127951 | 2008-11-18 00:00:00 | 75735 | -1 | 33
70516433 | 11983662 | 157127951 | 2008-11-18 00:00:00 | 75729 | 1 | 24.75
70516581 | 11984300 | 157147488 | 2008-11-18 00:00:00 | 75735 | -1 | 33
70516581 | 11984300 | 157147488 | 2008-11-18 00:00:00 | 75729 | 2 | 24.75
70516581 | 11984300 | 157147488 | 2008-11-18 00:00:00 | 75731 | -1 | 41.25
Spreadsheet: eric_saibi__9976__111501R
Sheet: San Juan 02

Owner Name |  | Public Service Company of New Mexico
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 02
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 350 MW
Start Date |  | 2001-11-10 00:00:00
End Date |  | 2001-11-14 00:00:00
Prv. Start Date |  | 2001-11-10 00:00:00
Prv. End Date |  | 2001-11-15 00:00:00
Comments |  | In startup right now, hoping to be at 100% by Friday evening.
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007770
Outage ID |  | 18881
Spreadsheet: 0a3354a0-0890-44bd-a508-d6e7c890ae93
Sheet: Index

.
Enrolled Time Calculator Index
Examples |  | Calculators
Daily Schedule - enrolled each period of the day |  | Daily Schedule
-  not enrolled the first period of the day
-  not enrolled the last period of the day
-  not enrolled in one or more period during the day
One Week Block - enrolled with a full schedule |  | One Week Block Schedule
-  not enrolled the first period
-  not enrolled the 7th or last  period of the day
-  not enrolled in one or more periods during the day
Two Week Block - enrolled with a full schedule |  | Two Week Block Schedule
-  not enrolled the first period of the day
-  not enrolled the sixth period of the day
-  not enrolled in one or more period during the day
Modified Block - enrolled with a full schedule |  | Modified Block Schedule
-  not enrolled the first period of the day
-  not enrolled the last period of the day
-  not enrolled one or more periods during the day
Enrolled one or more classes College - AVTS |  | Enrolled College or AVTS
Spreadsheet: 770797d1646255112-working-time-directive-calculations-timesheet2
Sheet: 31-1-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | S Barclay / T Buist
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | I Beveridge
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil |  | Leave
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | Last week | total taken | New Leave
 | [NAME] |  | 7.5 |  |  |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  |  |  |  |  | Leave
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 | 1 |  |  | 7.5 |  |  |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | AL | 8 |  | 7
 | [NAME] |  | 7.5 | 1 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  |  |  |  | 5
 | [NAME] |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK
 | [NAME] |  | 7.5 |  |  | TR | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL | 0 |  |  | AL |  |  |  |  | Leave
 | [NAME] |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 | 1 |  |  | 7 |  |  |  | 9 |  | 9 |  | Sick
 | [NAME] |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0
 | Vacant Post | 8.5 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 116213d1311682293-selective-columns-shendish-manor
Sheet: Bg

Basil. G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 39536d1237815759-formula-to-move-whole-row-full-example
Sheet: Sheet1

 | 2009-03-23 03:14:00 | po184 | PREV - UAA | 2009-03-23 02:30:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:17:00 | po185 | PREV - UAA | 2009-03-15 04:35:00 | Auto | Restriction | MN | en_US
 | 2009-03-23 03:19:00 | po186 | PREV - UAA | 2008-08-18 16:56:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:20:00 | po187 | PREV - P U CC Use | 2009-03-20 02:17:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:20:00 | po188 | PREV - P U CC Use | 2008-10-21 14:19:00 | Auto | Restriction | LV | en_US
 | 2009-03-23 03:21:00 | po189 | PREV - P U CC Use | 2009-03-17 14:43:00 | Auto | Restriction | MY | en_US
 | 2009-03-23 03:25:00 | po190 | PREV - P U CC Use | 2008-10-30 17:56:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:26:00 | po191 | PREV - P U CC Use | 2009-03-22 03:51:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:28:00 | po192 | PREV - P U CC Use | 2009-03-17 02:05:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:29:00 | po193 | PREV - UAA | 2009-03-01 18:33:00 | Auto | Restriction | IN | en_US
 | 2009-03-23 03:33:00 | po194 | AUTO - SP Sign IP | 2009-03-20 15:56:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:40:00 | po195 | AUTO - SP Sign IP | 2009-03-22 11:33:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:41:00 | po196 | AUTO - SP Sign IP | 2009-01-16 18:10:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:41:00 | po197 | AUTO - SP Sign IP | 2008-11-26 16:53:00 | Auto | Restriction | CA | en_US
 | 2009-03-23 03:42:00 | po198 | AUTO - SP Sign IP | 2009-03-19 23:34:00 | Auto | Restriction | SA | en_US
 | 2009-03-23 03:43:00 | po199 | AUTO - SP Sign IP | 2009-03-19 09:06:00 | Auto | Restriction | CA | en_US
 | 2009-03-23 03:47:00 | po200 | MRCHT - CHBK | 2009-03-09 21:44:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:51:00 | po201 | MRCHT - CHBK | 2009-03-19 13:47:00 | Auto | Restriction | BR | en_US
 | 2009-03-23 03:53:00 | po202 | MRCHT - CHBK | 2008-11-21 21:32:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:53:00 | po203 | MRCHT - CHBK | 2009-02-23 23:03:00 | Auto | Restriction | US | en_US
 | 2009-03-23 03:54:00 | po204 | MRCHT - CHBK | 2009-03-23 01:37:00 | Auto | Restriction | C2 | en_US
 | 2009-03-23 03:58:00 | po205 | PREV - UAA | 2009-03-18 17:49:00 | Auto | Restriction | US | en_US
 | 2009-03-23 04:02:00 | po206 | PREV - UAA | 2008-01-30 10:47:00 | Auto | Restriction | US | en_US
 | 2009-03-23 04:03:00 | po207 | PREV - UAA | 2009-02-02 14:11:00 | Auto | Restriction | HK | en_US
 | 2009-03-23 04:12:00 | po208 | PREV - UAA | 2009-03-22 14:35:00 | Auto | Restriction | US | en_US
 | 2009-03-23 04:12:00 | po209 | PREV - UAA | 2009-03-09 02:47:00 | Auto | Restriction | US | en_US
 | 2009-03-23 04:15:00 | po210 | PREV - UAA | 2009-03-11 03:10:00 | Auto | Restriction | US | en_US
 | 2009-03-23 04:18:00 | po211 | PREV - UAA | 2009-03-22 11:25:00 | Auto | Restriction | IN | en_US
Spreadsheet: 136631d1326749662-pull-data-if-columns-equal-a-range-copy-of-test2
Sheet: Sheet2

Item Id | Description | Qty | ITN | [NAME] | Date In | Days Old | Location | PO Number
Item 1 | Item 1 | 2 | 0 | 0 | 0 | 42 | 0 | 0
Item 1 | Item 1 | 2 | 0 | 0 | 0 | 42 | 0 | 0
Item 1 | Item 1 | 2 | 0 | 0 | 0 | 43 | 0 | 0
Item 1 | Item 1 | 2 | 0 | 0 | 0 | 43 | 0 | 0
Item 2 | Item 2 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 2 | Item 2 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 2 | Item 2 | 1 | 0 | 0 | 0 | 43 | 0 | 0
Item 2 | Item 2 | 1 | 0 | 0 | 0 | 43 | 0 | 0
Item 3 | Item 3 | 1 | 0 | 0 | 0 | 33 | 0 | 0
Item 3 | Item 3 | 1 | 0 | 0 | 0 | 33 | 0 | 0
Item 3 | Item 3 | 1 | 0 | 0 | 0 | 35 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 42 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 43 | 0 | 0
Item 4 | Item 4 | 1 | 0 | 0 | 0 | 43 | 0 | 0
Spreadsheet: 274878d1383246169-how-to-show-values-less-than-or-equal-to-another-value-in-drop-down-list-data-validation-marbles-2-
Sheet: Sheet1

Number of marbles |  | validation is here |  |  |  |  |  |  | Bag | Capacity of bag | validation calc
175 |  |  |  |  |  |  |  | Red | small bag | 60
 |  |  |  |  |  |  |  | Orange | large bag | 300
 |  |  |  |  |  |  |  | Yellow | extra large bag | 450
 |  |  |  |  |  |  |  | Green | normal bag | 150
 |  |  | in name manager
 |  |  | insert a named formula of
 |  |  | myrange | =Sheet1!$L$2:INDEX(Sheet1!$L$2:$L$5,COUNTIF(Sheet1!$L$2:$L$5,"<>0"))
Spreadsheet: andy_zipper__294__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 215 | 30 | 30.5 | 0.6785499999999991 | -0.03689999999999594
 | J | 220 | 38.5 | 39 | 0.5862499999999938 | -0.006599999999999273
 | K | 225 | 43.5 | 44 | 0.5148999999999972 | -0.01259999999999861
 | M | 235 | 49 | 50 | 0.478399999999999 | -0.01169999999999871
 | N | 240 | 56 | 57 | 0.4817999999999817 | -0.003299999999999637
 | Q | 245 | 63.5 | 65 | 0.4893499999999814 | -0.004199999999999537
 | U | 245 | 67.5 | 69.5 | 0.4854499999999818 | -0.00299999999999967
 | V | 245 | 73 | 74.5 | 0.4894999999999814 | 0.0008999999999999009
 | X | 270 | 84.5 | 87 | 0.4899499999999813 | 0.0008999999999999009
 | Z | 290 | 94 | 97 | 0.4828999999999821 | -0.003599999999999604
 | F | 300 | 105 | 107 | 0.4986000000000046 | -0.0008999999999999009
 | G | 295 | 104 | 108 | 0.4881000000000058 | -0.001499999999999835
 | H03 | 285 | 99 | 102 | 0.4597999999999978 | 0.004799999999999471
 | M03 | 280 | 88 | 90 | 0.3790000000000007 | -0.008699999999999042
 |  |  | 2002-02-01 14:36:33.780000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | H | 2050 | 160 | 170 | 0.4777499999999991 | 0.001349999999999851
 | J | 2050 | 265 | 275 | 0.4806999999999962 | 0.01949999999999785
 | K | 2100 | 350 | 365 | 0.4720499999999956 | 0.02399999999999736
 | M | 2100 | 395 | 410 | 0.4577499999999946 | 0.01379999999999848
 | N | 2100 | 430 | 450 | 0.4413999999999942 | 0.0154499999999983
 | Q | 2100 | 465 | 480 | 0.4294499999999944 | 0.01649999999999818
 | U | 2100 | 475 | 490 | 0.4088000000000001 | 0.008699999999999042
 | V | 2100 | 490 | 510 | 0.3938500000000015 | 0.008099999999999108
 | X | 2100 | 495 | 515 | 0.3754499999999869 | 0.005999999999999339
 | Z | 2100 | 500 | 520 | 0.3608999999999885 | 0.009299999999998976
 | M03 | 2100
 | Z03 | 2100
 |  |  | 2002-02-01 14:39:37.160000
Spreadsheet: 144897d1331199812-mod-function-replacement-__mod_query
Sheet: Sheet1

Recurring Account Revenue | Total Items
14.1 | 1
14.1 | 1
26 | 2
14.1 | 1
14.1 | 1
28.2 | 2
13 | 1
14.1 | 1
14.1 | 1
14.1 | 1
42.3 | 2.82
84.6 | 5.64
14.1 | 1
13 | 1
14.1 | 1
13 | 1
28.2 | 2
156 | 12
14.1 | 1
28.2 | 2
26 | 2
14.1 | 1
14.1 | 1
14.1 | 1
26 | 2
14.1 | 1
14.1 | 1
14.1 | 1
Spreadsheet: 782105d1653798606-using-xlookup-across-sheets-to-return-data-based-on-cell-testing
Sheet: QB (Manual results I want)

QB | Rankings
Player | Billy | [NAME] | Bright
X | 1 | 2 | 7
Z | 3 | 4 | 1
AB | 5 | 1 | 3
AE | 8 | 6 | 6
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: KP

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: cf6ec6b1-e74f-4059-bf02-9d05bd498c29
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
FPDM | Test | FPDM | Partial DMD Deletion/Duplication-Males only | Partial DMD Del/Dup Males | Dosage analysis of all exons on the DMD gene | EDTA (lavender-top) tube: EDTA |  |  | 30 | mL | 30 mL whole blood collected in a lavender-top (EDTA) tube(s). Send whole blood at ambient temperature.  Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed By:  Athena Diagnostics                                         377 Plantation St.                                         Four Biotech Park                                         Worcester, MA  01605 | Monday, Thursday | 14-21 days | 15-22 days | 1 | 81479 |  |  |  |  | Athena Diagnostics
FPDM | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FPDM | Result | Z0087 | Partial DMD Del/Dup Males | Partial DMD Del/Dup Males | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 881279d1729281166-place-value-from-one-cell-into-a-table-with-qualifier-from-two-other-cells-sample
Sheet: list

MODEL
MC100-2-1500
MC100-3-1500
MC100-2-3000
MC100-3-3000
MC160-2-1500
MC160-3-1500
MC160-2-3000
MC160-3-3000
MC3000 2 BL
MC5000 2 BL
[NAME]
GR100-3-3000
GR160-2-1500
GR160-3-1500
GR160-2-3000
GR160-3-3000
GR180-2-1500
[NAME]-3-1500
GR200-2-1500
GR200-3-1500
LB-GR80U-3-1500
LB-GR140U-3-1500
LB-GR200U-3-1500
Spreadsheet: 212956d1360295013-excel-report-from-many-categaories-and-have-a-summary-help
Sheet: details

year | supplier | description | comment | properties | category | value | date | split $ | Addit Comment | Receipt? | [NAME] | Exchange rate
2011 | Purchase |  | exchange rate 28.85 | Unit 37 | **Purchased amount** |  |  |  | Deposit for Randall |  | 100000 | 28.85 | -3466.2
2011 | Purchase |  | exchange rate 28.85 | Unit 37 | **Purchased amount** |  |  |  | Payment in Cash to Randall |  | 1300000 | 28.85 | -45060.66
2011 | homeworks |  | Hinges | Unit 37 | Living and Bedroon Renovation |  |  |  | hinges |  | 298 | 30.61
2012 | cleaning |  |  | Unit 37 | cleaning |  |  |  | befor new tenant |  | 350 | 30
2012 |  |  |  | Unit 37 | cleaning |  |  |  | Laundry |  | 180 | 30
2012 |  |  | Rent 10 October | Unit 37 | rental income |  |  |  | Oct |  | 15000 | -30
2012 |  |  | Rent 11 November | Unit 37 | rental income |  |  |  | Nov |  | 15000 | -30
2012 |  |  | Donation to pool | Unit 37 | body corporate fees and charges |  |  |  |  |  | 15000 | 30
2012 |  |  | [NAME] screen for balcony doors | Unit 37 | repairs and maintenance |  |  |  |  |  | 800 | 30
2012 |  |  | Rent 12 December | Unit 37 | rental income |  |  |  | Dec |  | 15000 | -30
2012 |  |  | Rent 01 January | Unit 37 | rental income |  |  |  | Jan |  | 15000 | -30
2012 |  |  | Maintenance fee 2012 | Unit 37 | body corporate fees and charges |  |  |  |  |  | 20160 | 30
2012 |  |  | Rent 02 Febuary | Unit 37 | rental income |  |  |  | Feb |  | 15000 | -30
2012 |  |  | Rent 03 March | Unit 37 | rental income |  |  |  | March |  | 15000 | -30
2012 |  |  | Commission one month for one year | Unit 37 | property agent fees/commission |  |  |  |  |  | 15000 | 30
2012 |  |  | Rent 04 April | Unit 37 | rental income |  |  |  | April |  | 15000 | -30
2012 | paid 15/06/2012 |  | Rent 05 May | Unit 37 | rental income | 500 |  |  | May |  | 15000 | -30
2012 |  |  | Rent 06 June | Unit 37 | rental income | 500 |  |  |  |  | 15000
2013 | paid 06/02/2013 |  |  | Unit 61 | **Purchased amount** | -2067.69 |  |  | Deposit |  | 60000 |  | Transferred from Aust CBA fee $22
2013 |  |  |  | Unit 61 | **Purchased amount** |  |  |  | Balance of purchase |  | 330000 | 30
2013 | yet to be paid |  |  | Unit 61 | Buying Costs |  |  |  | sinking fund |  | 32004 | -30
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013 |  |  | Rent 12 December | Pattaya | rental income
Spreadsheet: 54337d1254331374-changing-cell-colour-on-certain-conditions-copy-of-copy-of-quote-to-invoice-log-1-
Sheet: Sheet1

HALTON PANELCRAFT QUOTE TO INVOICE LOG
Enquiry No. | Date | Customer | Contact | Qty | Description | Value | Quoted By |  | Job No | Order Date | Customer PO No. | Order Value | [NAME] | Delivery Note No. | Date | Invoice No.
1000 | 2009-09-12 00:00:00 | Boulting | [NAME] | 2 | Panels 200 x 200 x 3 | 400 | JR |  | 14356 | 2009-09-29 00:00:00
1001 | 2009-08-01 00:00:00 | Nomenca | [NAME] | 1 | Dosing [NAME] painted [NAME] | 650 | JR |  | 14357
1002 | 2009-09-20 00:00:00 | Boulting | J.Mellor | 6 | Enclosures 100 x 100 x2 | 400 | JR
1003 | 2009-09-23 00:00:00 | Fords | A N Other | 1 | Transit Van | 2000 | DC
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
Spreadsheet: 856758d1705942980-how-to-create-an-index-formula-sample_data_set
Sheet: Sheet1

Retail Year | Month | Yr Month | Net Sales Units | Retail Price | Net Sales Units % Chg | Retail % Chg | Price Elasticity
2018 | January | 2018 - January | 4346 | 9.300016106764842 |  |  |  |  | 9.99
2018 | February | 2018 - February | 5126.2 | 6.604480902032695 | 0.1795213989875747 | -0.4081373305057976 | -0.4398553760448645
2018 | March | 2018 - March | 4044 | 8.462994559841741 | -0.211111544613944 | 0.2196047326590507 | -0.9613251137975573
2018 | April | 2018 - April | 3348 | 8.823183990442056 | -0.172106824925816 | 0.04082306693258343 | -4.215920994129102
2018 | May | 2018 - May | 4190 | 7.471980906921241 | 0.2514934289127838 | -0.1808359925370266 | -1.390726621312899
2018 | June | 2018 - June | 5515 | 7.343461468721668 | 0.3162291169451074 | -0.01750120685551099 | -18.06898915919786
2018 | July | 2018 - July | 3171 | 9.239545884578996 | -0.4250226654578422 | 0.2052140267003744 | -2.071118979008207
2018 | August | 2018 - August | 6139 | 6.122368463919205 | 0.9359823399558499 | -0.5091456744281517 | -1.838338980306768
2018 | September | 2018 - September | 5310 | 5.995706214689266 | -0.1350382798501385 | -0.02112549292685846 | 6.392195453979393
2018 | October | 2018 - October | 5397 | 6.114395034278303 | 0.01638418079096045 | 0.01941137576549245 | 0.8440504675658572
2018 | November | 2018 - November | 5903 | 6.150769100457394 | 0.09375579025384473 | 0.005913742750705126 | 15.85388377650782
2018 | December | 2018 - December | 7523 | 6.135037883822942 | 0.2744367270879214 | -0.002564159656769518 | -107.027940465171
2019 | January | 2019 - January | 6137 | 6.226081147140296 | -0.184235012627941 | 0.01462288414907197 | -12.5990885758083
2019 | February | 2019 - February | 6576 | 5.987553223844283 | 0.07153332247026234 | -0.03983729486464047 | -1.795637045972095
2019 | March | 2019 - March | 2576 | 9.028447204968943 | -0.6082725060827251 | 0.33681251184047 | -1.805967666577752
2019 | April | 2019 - April | 5308 | 7.23879992464205 | 1.06055900621118 | -0.2472298307672026 | -4.289769575621428
2019 | May | 2019 - May | 5319 | 7.216189133295733 | 0.002072343632253203 | -0.003133342395640751 | -0.6613843527398544
2019 | June | 2019 - June | 5751 | 7.122192662145714 | 0.08121827411167512 | -0.01319768723045184 | -6.153977791220508
2019 | July | 2019 - July | 4738 | 7.20175179400591 | -0.1761432794296644 | 0.01104719159113665 | -15.94462067363683
2019 | August | 2019 - August | 6217 | 6.946470966704198 | 0.3121570282819755 | -0.03674971485885751 | -8.49413470229249
2019 | September | 2019 - September | 4171 | 6.990611364181252 | -0.329097635515522 | 0.006314239939473925 | -52.11991287473009
2019 | October | 2019 - October | 4226 | 7.071332229058211 | 0.01318628626228722 | 0.01141522732382077 | 1.155148810288752
2019 | November | 2019 - November | 6759 | 6.688007101642254 | 0.5993847610033128 | -0.05731529910035991 | -10.45767483397027
Spreadsheet: 44986d1243791037-do-not-understand-mathmatical-formula-fractions-accumulated-interest
Sheet: Sheet1

1.0116666 | 1011.6666 | 1000 |  |  |  | 1.010979 | 1010.979 | 1000
 | 1023.46930955556 |  |  |  |  |  | 1022.078538441
 | 1035.409716602421 |  |  |  |  |  | 1033.299938714544
 | 1047.489427602135 |  |  |  |  |  | 1044.644538741691
 | 1059.710067758198 |  |  |  |  |  | 1056.113691132536
 | 1072.073281234706 |  |  |  |  |  | 1067.70876334748
 | 1084.580731377559 |  |  |  |  |  | 1079.431137860272
 | 1097.234100938248 |  |  |  |  |  | 1091.28221232284
 | 1110.035092300255 |  |  |  |  |  | 1103.263399731933
 | 1122.985427708085 |  |  |  |  |  | 1115.37612859759
 | 1136.086849498984 |  |  |  |  |  | 1127.621843113463
 | 1149.341120337349 |  |  |  |  |  | 1140.002003329006
Spreadsheet: 860691d1708696423-need-help-with-a-cost-report-function-cr2022
Sheet: Basic DB

 |  |  |  | Previous Month
 | CBS | Over / Under Budget | Growth Included in Forecast | Over / Under Budget | Growth Remaining
 | 20
 | 30
 | 40
 | 50
 | 60
 | 70
 | 80
 | 90
 | 100
Spreadsheet: drew_fossum__8889__gallup up front pmt
Sheet: Sheet3

[NAME] at 100% LF:
0-25% base load |  |  | /d
25%-95% var load |  |  | /d
0-95% energy load |  |  | /d
Fixed gas (non-var) |  |  | /d
 | O&M Expense |  |  | /d |  | MMBtu/d
 | 10MW Demand |  |  | /d |  | MMBtu/d
 | Cust Charge |  |  | /d |  | MMBtu/d
 | ECS Profit |  |  | /d |  | MMBtu/d
 | TW Gas stream |  |  |  |  | MMBtu/d
 | Markable Gas |  |  |  |  | MMBtu/d
 | Basis on Fixed gas |  |  |  |  | MMBtu/d
 | Total gas flow |  |  |  |  | MMBtu/d
 | [NAME] total possible flow (xport) |  |  |  |  | MMBtu/d