tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1764__090100winterload
Sheet: Winter

NPC/CES Daily Usage in Dekatherms for Winter 2000/2001
 |  | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00
BGE | All | 1217.007746077526 | 1731.194694892958 | 2020.537330697623 | 1837.018476008561 | 1375.473678747232
CMD | 4-25 | 186
CMD | 8-26 | 54
CMD | 8-27 | 215
CMD | 8-32 | 42
COH | 3-15 Portsmouth | 799.5 | 1164.516129032258 | 1351 | 1266.75 | 818.516129032258
COH | 5-2 Parma | 7657.5 | 10872.41935483871 | 12501.32258064516 | 12162.67857142857 | 9004.58064516129
COH | 5-7 Sandusky | 3064 | 4364.709677419355 | 5023.709677419355 | 4886.714285714285 | 3608.967741935484
COH | 7-5 Columbus | 14764.76666666667 | 20824.06451612903 | 23741.87096774194 | 22763.57142857143 | 16258.58064516129
COH | 7-4 Alliance | 1895.533333333333 | 2685.354838709678 | 3065.677419354839 | 2938.142857142857 | 2090.258064516129
COH | 7-6 Dayton | 2489.466666666667 | 3531.774193548387 | 4033.709677419355 | 3865.428571428572 | 2746.41935483871
COH | 7-1 Toledo | 15863.1 | 22496.1935483871 | 25690.32258064516 | 24619.35714285714 | 17498.38709677419
COH | 7-3 Lima | 2409.266666666667 | 3426.677419354839 | 3916.612903225806 | 3752.357142857143 | 2660.096774193548
COH | 7-8 Mansfield | 2639.033333333333 | 3765.83870967742 | 4308.451612903225 | 4126.535714285715 | 2916.806451612903
COH | 7-9 Ohio Misc. | 3274.8 | 4682.645161290323 | 5360.580645161291 | 5133.25 | 3621.870967741936
COH | 8-35 Pittsburgh | 1682 | 2383.258064516129 | 2738.83870967742 | 2646.785714285714 | 1887.161290322581
COH | 8-39 New Castle | 27.8 | 39.12903225806452 | 44.87096774193548 | 43.39285714285715 | 31.12903225806452
CPA | 4-25 | 4096
CPA | 8-26 | 40
CPA | 8-35 | 9023
CPA | 8-36 | 1
CPA | 8-38 | 115
CPA | 8-39 | 129
CVA | 10-30 | 1243
WGL | All | 1704
Spreadsheet: 25ed47dc-389e-416c-995f-ef35e8d7bfea
Sheet: EPR Rev Stats

Unaudited Supplemental Data
Revenue Metrics | Periods Ended September 30,
 | Fourth Quarters |  |  |  | Years
 | 2012 | 2011 | Ck #s |  | 2012 | 2011
In millions, unless otherwise noted
Gaming Operations
Revenues | 263.8 | 269.6 | 13.40000000000003 |  | 1040 | 1036.5
North America | 229.6 | 234.9 |  |  | 907.8 | 913.8000000000001
International | 34.2 | 34.7 |  |  | 132.2 | 122.7
Gross margin | 0.61 | 0.57 |  |  | 0.61 | 0.61
North America | 0.6 | 0.55 |  |  | 0.6 | 0.59
International | 0.71 | 0.72 |  |  | 0.7 | 0.73
Installed base ('000) | 57.10000000000001 | 53.9 |  |  | 57.10000000000001 | 53.9
North America | 43.40000000000001 | 40.9 |  |  | 43.40000000000001 | 40.9
International | 13.7 | 13 |  |  | 13.7 | 13
Average revenue per unit per day (0.00) | 50.83 | 55.33 |  |  | 51.49 | 53.34
Product Sales
Revenues | 313.4 | 256.8 |  |  | 966.8000000000001 | 883.9000000000001
North America | 224.2 | 161.4 |  |  | 648.2 | 566.2
International | 89.19999999999999 | 95.4 |  |  | 318.6 | 317.7
Machines | 217.5 | 171.7 |  |  | 653.5 | 558.1
North America | 152.9 | 100.9 |  |  | 421.3 | 324.7
International | 64.6 | 70.8 |  |  | 232.2 | 233.4
Non-machine | 95.9 | 85.1 |  |  | 313.3 | 325.8
North America | 71.3 | 60.5 |  |  | 226.9 | 241.5
International | 24.6 | 24.6 |  |  | 86.4 | 84.3
Gross margin | 0.56 | 0.54 |  |  | 0.54 | 0.55
North America | 0.58 | 0.56 |  |  | 0.57 | 0.56
International | 0.49 | 0.5 |  |  | 0.49 | 0.54
Units recognized ('000) | 14.5 | 11.3 |  |  | 43.6 | 37.5
North America | 10.4 | 7.1 |  |  | 29.1 | 22.8
International | 4.1 | 4.2 |  |  | 14.5 | 14.7
Units shipped ('000) [includes units where revenues deferred] | 14.6 | 11.1 | 0 |  | 44.2 | 35.9
North America | 10.4 | 6.5 |  |  | 29.3 | 20.9
New | 1.9 | 1.4 |  |  | 7.3 | 4.9
Replacement | 8.5 | 5.1 |  |  | 22 | 16
International | 4.2 | 4.6 |  |  | 14.9 | 15
New | 1.2 | 1.9 |  |  | 5.6 | 6.5
Replacement | 3 | 2.7 |  |  | 9.3 | 8.5
Average revenue per unit ('000) | 21.6 | 22.7 | 0 |  | 22.2 | 23.6
North America | 21.6 | 22.7 | 0 |  | 22.3 | 24.8
International | 21.8 | 22.7 | 0 |  | 22 | 21.6
Average machine sales price ('000) | 15 | 15.2 | 0 |  | 15 | 14.9
North America | 14.7 | 14.2 | 0 |  | 14.5 | 14.2
International | 15.8 | 16.9 | 0 |  | 16 | 15.9
Interactive
Revenues | 53.9 | 13.4 | -13.4 |  | 143.9 | 36.59999999999999
Social gaming | 35.8 | 0 |  |  | 87 | 0
IGTi | 18.1 | 13.4 |  |  | 56.9 | 36.59999999999999
Gross margin | 0.62 | 0.51 |  |  | 0.56 | 0.51
Social gaming | 0.61 | 0 |  |  | 0.61 | 0
IGTi | 0.65 | 0.51 |  |  | 0.49 | 0.51
Social Gaming (DoubleDown) Average User Statistics*
Daily active users (DAU) ('000) | 1415 |  |  |  | 1372
Monthly active users (MAU) ('000) | 5072 |  |  |  | 5097
Bookings per DAU (0.00) | 0.28 |  |  |  | 0.26
*as a single application with multiple games, active users equal unique users
Spreadsheet: 807227d1669810169-if-or-and-formula-help-costing-test
Sheet: Sheet1

 |  | Dimension (mm) |  | Description |  | Cost
 | Dim 'A' | 300 |  | Dim A, B, C are all under 300mm | <300 | 30
 | Dim 'B' | 250 |  | Dim A or B or C are equal to or greater than 300mm AND Dim A and B and C are less than 500mm | >=300 and <500 | 60
 | Dim 'C' | 250 |  | Dim A, B, C are all equal to or greater than 500mm AND less than or equal to 750mm | >=500 and <=750 | 90
 |  |  |  | Dim A or B or C are greater than 750mm | >750 | POA
 |  |  |  |  | Cost
Spreadsheet: af6e5bd1-c198-42ea-888e-0379cead7077
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (2 Entries):
 | 8 Medicine/public health 8.2 Diagnostic equipment 8.2.2 Blood analyzers
No. | Company | Country | City | [NAME] | Hall/Booth
1 | HSG-IMIT Institut für Mikro- und Informationstechnik der Hahn-Schickard-Gesellschaft | Germany | Villingen-Schwenningen | 78052 | A3.530
2 | Woodley Laboratory Diagnostics | United Kingdom | [NAME], [NAME] | BL6 5UE | B2.215A
Spreadsheet: 95502d1295086693-bar-chart-jsohng-disappearing-bars-when-data-present-test-chart-1
Sheet: Chart

 |  |  |  |  |  |  |  | Base | Positive | Negative
 |  |  |  |  |  |  | 2009 |  | 400
 |  |  |  |  |  |  | 1 | 400 | 10 | 0
 |  |  |  |  |  |  | 2 | 410 | 20 | 0
 |  |  |  |  |  |  | 3 | 430 | 4 | 0
 |  |  |  |  |  |  | 4 | 434 | 1 | 0
 |  |  |  |  |  |  | 5 | 435 | 1 | 0
 |  |  |  |  |  |  | 2010 |  | 436
Spreadsheet: 133015d1324087039-populating-a-table-from-a-dynamic-list-selection-tablematchmultiple
Sheet: Sheet1

 | Hook -001 |  |  |  |  |  | Hook -002 |  |  |  |  |  | Hook -003
 | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00 |  |  | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00 |  |  | 2011-04-11 00:00:00 |  |  | 2011-07-11 00:00:00 |  |  |  |  |  |  | 2 | 2
 | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms | X Fit Terms | Y Fit Terms | Z Fit Terms |  |  |  |  | 3
b | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
x | 2 | 4 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
x2 | 3 | 6 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
[NAME] | 4 | 8 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
y | 5 | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
xy | 6 | 12 | 18
y2 | 7 | 14 | 21
y3 | 8 | 16 | 24
z | 9 | 18 | 27
xz | 10 | 20 | 30
yz | 11 | 22 | 33
z2 | 12 | 24 | 36
z3 | 13 | 26 | 39
 |  | Hook Selection | Date Selection |  | X | Y | Z
 |  | Hook -002 | 2011-07-11 00:00:00 | b
 |  |  |  | x
 |  |  |  | x2
 |  |  |  | [NAME]
 |  |  |  | y
 |  |  |  | xy
 |  |  |  | y2
 |  |  |  | y3
 |  |  |  | z
 |  |  |  | xz
 |  |  |  | yz
 |  |  |  | z2
 |  |  |  | z3
Spreadsheet: 794500d1662080723-not-sure-which-formula-or-function-to-use-zipcode
Sheet: cust

Date Rec'd | Customer | # of units | CSS | Status | Line # on PM Agr. | Model | SN | Issue | Zip | Technician | Van | ZONE
2022-08-25 00:00:00 | Fashion Wheels | 10 | Arzhang | ~Waiting on CSS | 6 | 12-E90-13 | TBD | Need the SN. | 77301 | [NAME] | 34 | T-5
2022-08-30 00:00:00 | TSB Industrial | 1 | Kylie | Complete |  |  |  |  | 77304 | [NAME] | 34 | T-5
2022-08-30 00:00:00 | Perdue | 1 | Arzhang | Complete |  |  |  |  | 77268 | Chad D | 71
2022-08-30 00:00:00 | Lion's Floor | 3 | [NAME] | Complete |  |  |  |  | 77302 | [NAME] | 79
2022-08-30 00:00:00 | Champion Wholesale | 8 | Arzhang | ~Waiting on ownership |  | All batteries |  | Still on reserved sale | 77303 | Vic | 70
2022-08-30 00:00:00 | Busch USA | 2 | [NAME] | Complete |  |  |  |  | 77303 | Mike c | 59
2022-08-02 00:00:00 | Lions Floor | 6 | [NAME] | ~Waiting on CSS | 5 | 125 BCI 19 | 2205104 | Need pic of data tag to submit to IT. | 77306 | [NAME] | 79
2022-08-25 00:00:00 | Moore Supply | 4 | Arzhang | ~Waiting on CSS | 4 | EO | GGS3241 | Model not in quipware | 77302 | [NAME] | 77
2022-08-25 00:00:00 | Carolina Logistics | 3 | [NAME] | ~Waiting on CSS | 2 | 8FBE15U | 12852 |  | 77320 | Leo S | 65
2022-08-25 00:00:00 | [NAME] | 2 | Arzhang | Complete |  |  |  |  | 77316 | Calen R | 45
 | Harvest Natural - Spring | 1 | Vic | ~Other |  | C5 | 10251808 | Unit already signed up in May. Did they transfer to this location? | 77316 | Calen R | 45
Spreadsheet: 771401d1646656082-using-vlookup-on-multiple-columns-vlookup-example
Sheet: SPECIALS

 | candidate | ID | SPECIAL | OUTCOME
 | candidate 95 | 4186 | Y
 | candidate 16 | 6553 | Y
 | candidate 12 | 10314 | Y
 | candidate 42 | 10751 | Y
 | candidate 32 | 12849 | Y
 | candidate 77 | 13527 | Y
 | candidate 80 | 16071 | Y
 | candidate 48 | 18756 | Y
 | candidate 3 | 18924 | Y
 | candidate 67 | 23510 | Y
 | candidate 30 | 27175 | Y
 | candidate 44 | 27683 | Y
 | candidate 98 | 30729 | Y
 | candidate 17 | 33081 | Y
 | candidate 9 | 39716 | Y
 | candidate 26 | 41201 | Y
 | candidate 84 | 48435 | Y
 | candidate 43 | 51845 | Y
 | candidate 23 | 51902 | Y
 | candidate 91 | 57860 | Y
 | candidate 41 | 60954 | Y
 | candidate 37 | 63493 | Y
 | candidate 11 | 69182 | Y
 | candidate 88 | 71834 | Y
 | candidate 25 | 71982 | Y
 | candidate 24 | 75811 | Y
 | candidate 22 | 78117 | Y
 | candidate 50 | 78197 | Y
 | candidate 60 | 78414 | Y
 | candidate 7 | 79223 | Y
 | candidate 20 | 79396 | Y
 | candidate 21 | 82086 | Y
 | candidate 13 | 83027 | Y
 | candidate 85 | 83357 | Y
 | candidate 14 | 94041 | Y
 | candidate 71 | 94757 | Y
 | candidate 63 | 96215 | Y
 | candidate 15 | 98831 | Y
Spreadsheet: 240167d1370243742-print-sheet-calculator-papercalc
Sheet: Sheet1

 |  |  |  |  |  |  |  | Size | L | W | Area
 | Paper Product | L | W | Quantity |  |  |  | DL | 99 | 210
Output | DL |  |  | 300 | Input Quantity |  |  | DLE | 110 | 220
 |  |  |  |  |  |  |  | F4 | 210 | 330
 | Paper Source | L | W | Required |  |  |  | RA0 | 841 | 189
Input | SRA3 |  |  |  | Answer |  |  | RA1 | 610 | 860
 |  |  |  |  |  |  |  | RA2 | 430 | 610
 |  |  |  |  |  |  |  | RA3 | 305 | 430
 |  |  |  |  |  |  |  | RA4 | 215 | 305
 |  |  |  |  |  |  |  | SRA0 | 900 | 280
 |  |  |  |  |  |  |  | SRA1 | 640 | 900
 |  |  |  |  |  |  |  | SRA2 | 450 | 640
 |  |  |  |  |  |  |  | SRA3 | 320 | 450
 |  |  |  |  |  |  |  | SRA4 | 225 | 320
 |  |  |  |  |  |  |  | A3+ | 329 | 483
Spreadsheet: 784733d1655926990-estimate-at-complete-hours-eac-worksheet
Sheet: Assignment (16)

*project_org_code | project_code | task_name | username | begin_date | end_date | delete | budget_hours | exceed_budget | bill_rate | cost_rate | project_org_override | person_org_override | labor_category | location | etc_hours | use_wbs_dates | cost_structure | cost_element | edc | ic_cost_rate | ic_cost_structure | ic_cost_element
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-02-01 00:00:00 | 2022-02-28 00:00:00 |  | 125 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 |  | 130 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 |  | 140 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-05-01 00:00:00 | 2022-05-31 00:00:00 |  | 135 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-06-01 00:00:00 | 2022-06-30 00:00:00 |  | 130 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-07-01 00:00:00 | 2022-07-31 00:00:00 |  | 125 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-08-01 00:00:00 | 2022-08-31 00:00:00 |  | 140 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 1 | JDOE1 | 2022-09-01 00:00:00 | 2022-09-30 00:00:00 |  | 145 | Y | L | P |  |  | LCAT A |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-02-01 00:00:00 | 2022-02-28 00:00:00 |  | 135 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-03-01 00:00:00 | 2022-03-31 00:00:00 |  | 165 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-04-01 00:00:00 | 2022-04-30 00:00:00 |  | 150 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-05-01 00:00:00 | 2022-05-31 00:00:00 |  | 150 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-06-01 00:00:00 | 2022-06-30 00:00:00 |  | 160 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-07-01 00:00:00 | 2022-07-31 00:00:00 |  | 140 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-08-01 00:00:00 | 2022-08-31 00:00:00 |  | 160 | Y | L | P |  |  | LCAT B |  |  | N
C_CustomerName | Project Name 1 | TTO 5 | [NAME] | 2022-09-01 00:00:00 | 2022-09-30 00:00:00 |  | 145 | Y | L | P |  |  | LCAT B |  |  | N
Spreadsheet: 844915d1696522566-creating-a-days-on-hand-formula-counting-down-to-zero-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Backlog | Backlog | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 2023-10-07 00:00:00 | 2023-10-08 00:00:00 | 2023-10-09 00:00:00 | 2023-10-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Expected | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Demand |  | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Projected | 50 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual DOH | 0
Spreadsheet: 817943d1676518874-display-the-average-of-the-previous-10-games-dynamically-bostoncelticsplayers
Sheet: BOS Total

SheetName | Player | Team | POS | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS | GMSC | PM
White_Derrick | [NAME] | BOS | SG
Williams_Grant | [NAME] | BOS | PF
Hauser_Sam | [NAME] | BOS | PF
Tatum_Jayson | [NAME] | BOS | PF
Brown_Jaylen | [NAME] | BOS | SF
Kornet_Luke | [NAME] | BOS | C
Brogdon_Malcolm | [NAME] | BOS | PG
Smart_Marcus | [NAME] | BOS | PG
Horford_Al | [NAME] | BOS | C
Pritchard_Payton | Payton Pritchard | BOS | PG
Griffin_Blake | Blake Griffin | BOS | C
Williams_Robert | [NAME] | BOS | C
Davison_JD | [NAME] | BOS | PG
Kabengele_Mfiondu | [NAME] | BOS | PF
Muscala_Mike | [NAME] | BOS | C
Spreadsheet: 873426d1719926594-sum-adding-up-multiple-values-into-one-total-value-book1
Sheet: Sheet1

 | Person | Area | Low | Medium | High | Dedicated | Total |  |  | Area | [NAME] | Currenrt
 | Person 1 | Aea 1 | 0 | 0 | 0 | 1 |  |  |  | Aea 1 | 7
 | Person 2 | Aea 1 | 0.25 | 0.5 | 0 | 0 |  |  |  | Aea 2 | 7
 | Person 3 | Aea 1 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  | Aea 3 | 5
 | Person 4 | Aea 1 | 0.3 | 0.3 | 0.3 | 0 |  |  |  | Aea 4 | 4
 | Person 5 | Aea 1 | 0.55 | 0 | 0 | 0
 | Person 6 | Aea 1 | 0.2 | 0.25 | 0 | 0.1
 | Person 7 | Aea 1 | 0.55 | 0.25 | 0.1 | 0
 | Person 8 | Aea 2 | 0 | 0 | 0 | 0
 | Person 9 | Aea 2 | 0 | 0 | 0 | 0
 | Person 10 | Aea 2 | 0 | 0 | 0 | 0
 | Person 11 | Aea 2 | 0 | 0 | 0 | 0
 | Person 12 | Aea 2 | 0 | 0 | 0 | 0
 | Person 13 | Aea 2 | 0 | 0 | 0 | 0
 | Person 14 | Aea 2 | 0 | 0 | 0 | 0
 | Person 15 | Aea 3 | 0 | 0 | 0 | 0
 | Person 16 | Aea 3 | 0 | 0 | 0 | 0
 | Person 17 | Aea 3 | 0 | 0 | 0 | 0
 | Person 18 | Aea 3 | 0 | 0 | 0 | 0
 | Person 19 | Aea 4 | 0 | 0 | 0 | 0
 | Person 20 | Aea 4 | 0 | 0 | 0 | 0
 | Person 21 | Aea 4 | 0 | 0 | 0 | 0
 | Person 22 | Aea 4 | 0 | 0 | 0 | 0
 | Person 23 | Aea 4 | 0 | 0 | 0 | 0
Spreadsheet: 720650d1614230493-inserting-additional-criteria-to-an-if-statement-wrkswipes2erref
Sheet: Error 1

 | Overall Day | ARR | STRT | END | WRK | RT | WT |  | Overall Day | ARR | STRT | END | WRK | RT | WT
 |  | 06:20:00 | 06:30:00 | 10:32:00 |  |  |  |  |  | 05:28:00 | 05:38:00 | 10:25:00
 | Break | 13:50:00 | 14:00:00 | 18:32:00 |  |  |  |  | Break | 14:50:00 | 15:00:00 | 16:00:00
 |  |  |  | Total |  |  |  |  |  | 16:00:00 | 16:10:00 | 18:14:00
 |  |  |  |  |  |  |  |  |  |  |  | Total
 | 11th Hour |  |  |  | ST | OT
 | 11 1/2 Hour |  |  |  |  |  |  |  | 11th Hour |  |  |  | ST | OT
 | Guarantee | 8:00:00 |  |  | 8 |  |  |  | 11 1/2 Hour
 | 11 1/2-11 |  |  |  |  |  |  |  | Guarantee | 8:00:00
 |  |  |  |  |  |  |  |  | 11 1/2-11
Spreadsheet: 119791d1314742594-get-value-of-intersection-of-column-array-and-row-array-help
Sheet: Sheet1

 | Blue colour highlighted cell is variable for flexible planning
age until retirement
age@today | 28
age of retirement | 55 | change this value to 45 , then the hire purchase's payment on age a45 onwards should stop
 |  | how to adjust the formula according to me variable change and automatically entered into the cell?
age to start payment for hire purchase | 30
payment period(years) | 18
saving amount | 1410
age to start saving for wedding | 28
saving period(years) | 4
 | 3200
 |  | hire purchase | wedding
1
Spreadsheet: 57486d1257687806-cross-referencing-columns-hevybreathinharlot
Sheet: Sheet1

1 | 8 | 2 | 9 | 3 | 2 | Yes
2 | 8 | 1 | 3 | 2
3 | 3 | 10 | 2 | 9
4 | 7 | 5 | 4 | 7
5 | 10 | 4 | 8 | 3
6 | 8 | 10 | 6 | 2
7 | 1 | 6 | 5 | 9
8 | 10 | 1 | 1 | 6
9 | 2 | 2 | 9 | 2
10 | 4 | 10 | 5 | 5
Spreadsheet: 706210d1606531079-create-unique-list-from-multiple-columns-using-unique-course-test
Sheet: Sheet1

 | Course 1 | Course 2 | Course 3 | Course 4 | Course 5
 | Python for Engineers | Ground Improvement Training | Airphoto Interpretation | Flow3D | GeoStudio Training
 | Facilitation Training | [NAME] | Feedback Training | Other | Other
 | Python for Engineers | Televiewer Data Interpretation | Drilling 201 | Construction Monitor Training | Project Management
 | Civil Geotech Training | Drilling 101 | Glacial Deposition | GeoStudio Training | Drilling 201
 | Speak Like a Leader [NAME] | Python for Engineers | [NAME]
 | Drilling 101 | [NAME] | Construction Monitor Training | [NAME] | Glacial Deposition
 | HEC-RAS 1D + 2D | [NAME] | [NAME] | GeoStudio Training | Glacial Deposition
 | Python for Engineers | Dams 101 | [NAME] | GeoStudio Training
 | Glacial Deposition | Pipeline Lead Inspector Training | Civil Geotech Training | Speak Like a Leader [NAME] | Airphoto Interpretation
 | Airphoto Interpretation | Drilling 101 | Pipeline New Inspector Training | Construction Monitor Training | Hydrogeology 101
 | Glacial Deposition | Structural Geology | [NAME] | Pipeline Construction and Geotechnical Field Support | Drilling 101
 | Speak Like a Leader [NAME] | Leadership Foundation | Python for Engineers | HEC-RAS 1D + 2D | Flow3D
 | Facilitation Training
 | Python for Engineers
 | Civil Geotech Training
 | Speak Like a Leader [NAME]
 | Drilling 101
 | HEC-RAS 1D + 2D
 | Python for Engineers
 | Glacial Deposition
 | Airphoto Interpretation
 | Glacial Deposition
 | Speak Like a Leader [NAME]
 | Ground Improvement Training
 | [NAME]
 | Televiewer Data Interpretation
 | Drilling 101
 | Python for Engineers
 | [NAME]
 | [NAME]
 | Dams 101
 | Pipeline Lead Inspector Training
 | Drilling 101
 | Structural Geology
 | Leadership Foundation
 | Airphoto Interpretation
 | Feedback Training
 | Drilling 201
 | Glacial Deposition
 | [NAME]
 | Construction Monitor Training
 | [NAME]
 | [NAME]
 | Civil Geotech Training
 | Pipeline New Inspector Training
 | [NAME]
 | Python for Engineers
 | Flow3D
 | Other
 | Construction Monitor Training
 | GeoStudio Training
 | [NAME]
 | GeoStudio Training
 | GeoStudio Training
 | Speak Like a Leader [NAME]
 | Construction Monitor Training
 | Pipeline Construction and Geotechnical Field Support
 | HEC-RAS 1D + 2D
 | GeoStudio Training
 | Other
 | Project Management
 | Drilling 201
 | Glacial Deposition
 | Glacial Deposition
 | Airphoto Interpretation
 | Hydrogeology 101
 | Drilling 101
 | Flow3D
Spreadsheet: 27777d1221395572-days-elapsed-and-alert-tracker-sample
Sheet: Tracker

Agent Name | Time | Date | Create date & Time | Time | Date | [NAME] | R Number | Categories | Team | Technicians | Importance | Request Through | Status | Priority | Days Elapsed | Current Date & Time
[NAME] | 12:51:02 | 2008-09-14 00:00:00 | 2008-09-14 12:51:02 | 12:51:02 | 2008-09-14 00:00:00 | kate | 123 | F1 | [NAME] | sean | High | Telephone | Open |  | Ideally Q-D | current date and time
[NAME] | 14:44:12 | 2008-09-14 00:00:00 | 2008-09-14 14:44:12 | 14:44:12 | 2008-09-14 00:00:00 | [NAME] | 234 | G2 | Service | Morgan | low | Chat | Closed |  | Ideally Q-D .  Stop on the date when the Status goes to Closed or Resolved and display only information till then | current date and time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | current date and time
Spreadsheet: debra_perlingiere__8424__Michigan Consolidated Gas Company
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
Enron Entity: | ENA | ATTORNEY:
DATE: | 2001-10-10 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Michigan Consolidated Gas Company | CONTACT: | [NAME]
ADDRESS: | 500 Griswold Street | TITLE:
 | FLR 26 | PHONE: | [PHONE]
 | Detroit MI 48226 | FAX: | [PHONE]
INCORPORATION STATE: |  | S&P RATING: | BBB+
STRUCTURE | COUNTERPARTY | ENA
COLLATERAL | $10.00MM | $10.00MM
THRESHOLD in $[NAME]
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) |  | Enron Corp (BBB+)
LIMIT in $[NAME] |  | $10.00MM
Incorporation State:
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | BBB-/Baa3 | BBB-/Baa3 | S&P/Moody's
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty | $35MM
-Guarantor ($[NAME]) |  | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X5-3596