tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818635d1676980801-figure-weight-when-seeing-space-1919-stone-weights
Sheet: SEQ

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Sh:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Rem:
PM: |  |  |  |  | PCS: |  |  | TRUCK CUBE: |  |  | SHIP DATE: |  |  |  |  |  |  | Total CF Sh:
TOTAL CUBE: |  |  |  |  | WT: |  |  | NET CUBE: |  |  |  |  |  |  |  |  |  | Total CF Rem:
R | S | P | J | CNC | L | RETURN | SORT | MARK | PCS | CF/PC: | NET CF: | Running CF: | Pcs Sh: | Pcs Rem: | CF Ship: | CF Rem: | ACF: | Truck Weight:
 |  |  |  |  |  |  |  | add | 1 | 2
 |  |  |  |  |  |  |  | ref | 1 | 2.67
 |  |  |  |  |  |  |  | rep | 1 | 4
 |  |  |  |  |  |  |  | 300 | 1 | 1.97 |  |  |  |  |  |  | 1.97
 |  |  |  |  |  |  |  | 362 | 1 | 3.98 |  |  |  |  |  |  | 4.06
 |  |  |  |  |  |  |  | 411 | 1 | 12.42 |  |  |  |  |  |  | 14.12
 |  |  |  |  |  |  |  | 404 | 1 | 10.96 |  |  |  |  |  |  | 12.41
 |  |  |  |  |  |  |  | band | 1 | 0.58 |  |  |  |  |  |  | 0.68
 |  |  |  |  |  |  |  | base | 1 | 3.7 |  |  |  |  |  |  | 3.94
 |  |  |  |  |  |  |  | corner | 1 | 4.78 |  |  |  |  |  |  | 5.16
 |  |  |  |  |  |  |  | rail | 1 | 2.17 |  |  |  |  |  |  | 2.45
 |  |  |  |  |  |  |  | [NAME] | 1 | 0.24 |  |  |  |  |  |  | 0.24
 |  |  |  |  |  |  |  | s cap | 1 | 0.84 |  |  |  |  |  |  | 0.84
 |  |  |  |  |  |  |  | spindle | 1 | 0.3 |  |  |  |  |  |  | 0.38
 |  |  |  |  |  |  |  | 1 | 1 | 3.41 |  |  |  |  |  |  | 5.37
 |  |  |  |  |  |  |  | 2 | 1 | 2.2 |  |  |  |  |  |  | 5.2
 |  |  |  |  |  |  |  | rf | 1 | 1.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Sh:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Rem:
PM: |  |  |  |  | PCS: |  |  | TRUCK CUBE: |  |  | SHIP DATE: |  |  |  |  |  |  | Total CF Sh:
TOTAL CUBE: |  |  |  |  | WT: |  |  | NET CUBE: |  |  |  |  |  |  |  |  |  | Total CF Rem:
R | S | P | J | CNC | L | RETURN | SORT | MARK | PCS | CF/PC: | NET CF: | Running CF: | Pcs Sh: | Pcs Rem: | CF Ship: | CF Rem: | ACF: | Truck Weight:
 |  |  |  |  |  |  |  | E1 | 1 | 23 |  |  |  |  |  |  | 18.3
 |  |  |  |  |  |  |  | E2 | 1 | 7.44 |  |  |  |  |  |  | 4.87
 |  |  |  |  |  |  |  | E3 | 1 | 6.4 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | E4 | 1 | 4.87 |  |  |  |  |  |  | 5
Spreadsheet: andy_zipper__747__Global_Prod 10-26-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
For Curr Exch    Forward                 29Oct01         JPY/USD
For Curr Exch    Forward                 29Oct01         USD/EUR
For Curr Exch    Forward                 29Oct01         USD/GBP
For Curr LME     LME (Spot)              29Oct01         JPY/USD
For Curr LME     LME (Spot)              29Oct01         USD/EUR
For Curr LME     LME (Spot)              29Oct01         USD/GBP
GO 0.2% Phy EFP  FOB ARA IPE             16-31Dec01      USD/mt
SG E-W GO Diff   Platts/IPE              Dec01           USD/mt
SG Gasoil Swap   Platts AP               Nov01           USD/bbl
Tkr Freight Swap IITRA                   Dec01           WS/mt
Tkr Freight Swap IITRA                   Jan02           WS/mt
Tkr Freight Swap IITRA                   Nov01           WS/mt
Tkr Freight Swap IITRA                   Oct01           WS/mt
[NAME]                  Dec01           WS/mt
[NAME]                  Jan02           WS/mt
[NAME]                  Nov01           WS/mt
US Coal Phy      Nymex Spec              Apr-Jun02       USD/ST-b
US Coal Phy      Nymex Spec              Jan-Mar02       USD/ST-b
US Coal Phy      Nymex Spec              Jul-Sep02       USD/ST-b
US Coal Phy      Nymex Spec              Oct-Dec02       USD/ST-b
US Crude Fin Opt NYMEX WTI    EP22.5     Dec01           USD/bl/m
US Prop FOB Phy  [NAME]                 Nov01           c/Gl-b
US Prop FOB Phy  CONWY                   Nov01           c/Gl-b
US ResidOil Spd  NYH 1% Crack Spread     Jan-Dec02       USD/bl/m
Spreadsheet: 21bec62a-0106-46f6-8241-8e1ca1c6b083
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflower | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 |  |  |  | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/121 | 51.75 | 52.5 | 84.5 | 56.5 | 99.5 | 55.75 | 53.75 | 51.5
2012/131 | 52.5-56.5 | 54.5-58.5 | 88.0-92.0 | 58.0-62.0 | 97.5-101.5 | 58.0-62.0 | 48.5-52.5 | 48.0-52.0
2010/11
October | 44.02 | 47.2 | 56 | 51.45 | 71.4 | 47.5 | 46.64 | 37
November | 47.62 | 50.75 | 63 | 53.63 | 75.13 | 51.96 | 37.32 | 41.75
December | 51.51 | 54 | 62.9 | 58.25 | 77.9 | 54.71 | 38.3 | 45
January | 53.84 | 55.92 | 74.125 | 59.5 | 80.06 | 57.91 | 48.5 | 50.1
February | 54.21 | 56.75 | 85.625 | 60.13 | 79.63 | 63.39 | 49.6 | 49.9
March | 54.07 | 55.5 | 96.75 | 60.25 | 77.5 | 67.72 | 52 | 51.75
April | 56.65 | 57.7 | 101.2 | 62.05 | 78.7 | 68.89 | 51.5 | 52.83
May | 56.09 | 56.06 | 103.75 | 60.19 | 82.81 | 68.33 | 54.31 | 53.87
June | 55.68 | 55.25 | 103.25 | 59.56 | 78.5 | 66.7 | 56.75 | 57.41
July | 55.16 | 54.75 | 97 | 60.7 | 88.05 | 62 | 63 | 60.89
August | 54.39 | 54.75 | 95 | 60 | 95.56 | 62 | 58.96 | 56.35
September | 55.13 | 55.35 | 94.8 | 58.45 | 97.5 | 57.95 | 61.33 | 59.28
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
[NAME] | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2012-07-13 07:57:22.330000
Spreadsheet: 126207d1319565974-counting-instances-of-a-string-in-non-contiguous-columns-example
Sheet: 72711(2) Opens

[NAME]
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
[EMAIL] | x
Spreadsheet: 786654d1657336016-calculate-average-of-time-difference-based-on-non-duplicate-criteria-sample
Sheet: Sheet1

Trades | Entry  Time (CT) | Exit Time (CT) |  |  | Right Answer |  | Incorrect Answer
1 | 07:33:00 | 07:45:00 |  |  |  |  |  |  |  | 07:33:00 | 07:45:00
2 | 08:15:00 | 08:17:00 |  |  |  | 00:02:00 |  | 2 | 2 | 08:15:00 | 08:17:00
2 | 08:15:00 | 08:17:00 |  |  |  | 00:02:00 |  | 3 | 3 | 08:30:00 | 08:58:00
3 | 08:30:00 | 08:58:00 |  |  |  | 00:28:00 |  | 4 | 4 | 08:31:00 | 08:32:00
3 | 08:30:00 | 08:58:00 |  |  |  | 00:28:00 |  | 5 | 5 | 08:32:00 | 08:33:00
4 | 08:31:00 | 08:32:00 |  |  |  | 00:01:00 |  | 6 | 6 | 09:09:00 | 09:09:00
4 | 08:31:00 | 08:32:00 |  |  |  | 00:01:00 |  | 7 | 7 | 09:11:00 | 09:11:00
5 | 08:32:00 | 08:33:00 |  |  |  | 00:01:00 |  | 8 | 8 | 09:11:00 | 09:12:00
5 | 08:32:00 | 08:33:00 |  |  |  | 00:01:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
6 | 09:09:00 | 09:09:00 |  |  |  | 00:00:00
7 | 09:11:00 | 09:11:00 |  |  |  | 00:00:00
7 | 09:11:00 | 09:11:00 |  |  |  | 00:00:00
8 | 09:11:00 | 09:12:00 |  |  |  | 00:01:00
Average Hold Time =
Spreadsheet: 8af268d0-1e72-4efd-bbcd-902534ea8030
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Patapsco and Back Rivers for 2010
Indicator | 2010
Chlorophyll a | 0
Aquatic Grasses | 0
[NAME] | 52.63
[NAME] | 45.45455
Water Clarity | 0
Phytoplankton Index | 0
Water Quality Index | 17.54333333
Biotic Index | 15.15151667
Bay Health Index | 16.347425
Spreadsheet: 760441d1640202126-an-alternate-for-nested-if-sample
Sheet: Summary

Part | Group | Std Cost | LPP | Delta | On Hand | 2022 Req | Excess | On Order | Last Purchase Date | Month and Year | Suggested Std Cost
101 | Group A | 2 | 1 |  | 10 | 20 |  | 0 | 2021-12-02 00:00:00
102 | Group A | 3 | 6 |  | 5 | 4 |  | 2 | 2021-01-01 00:00:00
103 | Group B | 4 | 7 |  | 4 | 2 |  | 2 | 2021-06-25 00:00:00
104 | Group B | 5 | 8 |  | 6 | 10 |  | 10 | 2021-02-04 00:00:00
105 | Group C | 12 | 15 |  | 80 | 100 |  | 50 | 2021-03-15 00:00:00
106 | Group C | 15 | 15 |  | 100 | 50 |  | 0 | 2021-08-05 00:00:00
107 | Group D | 4 | 6 |  | 20 | 30 |  | 0 | 2021-09-21 00:00:00
108 | Group D | 8 | 10 |  | 15 | 20 |  | 10 | 2021-02-02 00:00:00
109 | Group E | 7 | 9 |  | 200 | 250 |  | 100 | 2021-07-08 00:00:00
110 | Group E | 50 | 65 |  | 10 | 8 |  | 0 | 2021-11-21 00:00:00
 |  |  | List of criteria:
- If LPP<[NAME] cost and (2022 Req = 0,On Order=0), return LPP |  |  |  |  |  |  | 1
- if LPP>Std cost and (2022 Req=0, On Order=0), return [NAME] cost |  |  |  |  |  |  | 2
- if LPP>Std and (2022 Req<>0, On Order=0), return LPP |  |  |  |  |  |  | 3
- If LPP<[NAME] and (2022Req=0, On Order<>0, group = Group B), return LPP, if group<>Group B but everything else is TRUE, return [NAME]) |  |  |  |  |  |  | 4
- If LPP>Std and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return LPP |  |  |  |  |  |  | 5
- If LPP<[NAME] and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return the LPP or [NAME] (which ever is the highest) |  |  |  |  |  |  | 6
Spreadsheet: theresa_staab__39595__Kennedy email
Sheet: South Kitty

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0.61 | 0.596
[NAME] |  |  |  | 0.47 | 0.456
S. Kitty Net Backs: |  | Index Discount/Premium | EMS Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | SOUTH KITTY
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total South Kitty Allocated [NAME] | Total South Kitty Production MMBtu | Total Purchased Production MMBtu | Total South Kitty Payments by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | (7% [NAME] to Maverick)
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 153625d1335978876-excel-2007-handling-duplicates-with-index-match-copy-of-excel-help-needed
Sheet: Sheet1

Key Systems | # instances
system 1 | 17
system 2 | 17 |  | System
system 3 | 17 |  | Instances
system 4 | 0
system 5 | 0
system 6 | 0
system 7 | 22
system 8 | 1 |  |  |  |  |  |  | should be system 2 &3
system 9 | 0
system 10 | 16
system 11 | 0
system 12 | 20
system 13 | 0
system 14 | 0
system 15 | 0
system 16 | 0
system 17 | 5
system 18 | 0
system 19 | 0
system 20 | 0
system 21 | 7
system 22 | 0
system 23 | 0
system 24 | 0
system 25 | 8
system 26 | 0
system 27 | 0
system 28 | 0
system 29 | 0
system 30 | 0
system 31 | 0
system 32 | 0
system 33 | 0
system 34 | 0
system 35 | 0
system 36 | 0
system 37 | 0
system 38 | 0
system 39 | 0
system 40 | 0
system 41 | 0
system 42 | 0
system 43 | 19
system 44 | 1
system 45 | 4
system 46 | 0
system 47 | 0
system 48 | 0
system 49 | 0
Spreadsheet: 728987d1618847283-match-codes-from-file-1636-match-codes-from-file-master-code-list
Sheet: Wk16 Update

 |  | 050001 332210901 |  | WASH
 |  | 522287 SPM |  | SWEEP
 |  | 580824 SPM |  | SWEEP
 |  | 508053 SPM |  | WASH
 |  | 534199 65SPM |  | SWEEP
 |  | 554274 [NAME] |  | WASH
 |  | 589674 CB |  | WASH
 |  | 589905 1CB |  | SWEEP
 |  | 513796 CB |  | WASH
 |  | 513140 1CB |  | WASH
 |  | 554628 1CB |  | WASH
 |  | 589682 CB |  | WASH
 |  | 871023 SPM |  | WASH
 |  | 523748 1CB |  | WASH
 |  | 581230 2CB |  | WASH
 |  | 513111 CB |  | WASH
 |  | 513310 CB |  | WASH
 |  | 589461 6CB |  | WASH
 |  | 589631 CBEU |  | WASH
 |  | 548168 CB |  | WASH
 |  | 548169 2CB |  | WASH
 |  | 585270 SPM |  | WASH
 |  | 050001 33229086 |  | WASH
 |  | 585309 1SPM |  | WASH
 |  | 585289 2SPM |  | WASH
 |  | 534199 SPM |  | WASH
 |  | 543075 1CBGB |  | WASH
 |  | 575905 CB |  | WASH
 |  | 554097 CB |  | WASH
 |  | 554201 CB |  | WASH
 |  | 589817 6CB |  | WASH
 |  | 589105 SPM |  | WASH
 |  | 589659 CB |  | WASH
 |  | 588884 2CB |  | WASH
 |  | 513153 CB |  | SWEEP
 |  | 589858 3CB |  | WASH
 |  | 555385 CB |  | WASH
 |  | 579201 SPM |  | WASH
 |  | 579116 CBEU |  | WASH
 |  | 575765 SPM |  | SWEEP
 |  | 566060 SPM |  | WASH
 |  | 589206 CB |  | WASH
 |  | 554490 9CB |  | WASH
 |  | 513281 CB |  | WASH
 |  | 578496 1CBEU |  | SWEEP
 |  | 589092 CBEU |  | WASH
Spreadsheet: john_griffith__15705__Hedge Ratio
Sheet: Sheet1

Hedge Ratio
As of: | 2000-12-15 00:00:00
Hedge Ratio = Correlation * ([NAME] (C1)/Stdev (C2))
C1 = Commodity 1 (Power)
C2 = Commodity 2 (Gas)
 |  | Executed |  |  | Executed
 | Hedge | Power Volume | Implied | Gas Hedge | Power | Gas Price
Month | Ratio | MWhrs/month | Heat Rate | MMBtu's/month | Price | Needed
 |  |  |  |  | 60
Spreadsheet: 92283d1291901401-how-to-find-a-formula-with-two-variables-solution-of-example
Sheet: Sheet1

Example i am trying to solve
Variable A | Variable B | Sullution |  | Factor b
100 | 80 | 47.513
90 | 90 | 45.53299999999999
98 | 65 | 53.968
87 | 76 | 51.79000000000001
67 | 70 | 58.308
60 | 60 | 63.773
90 | 55 | 59.63799999999999
80 | 50 | 63.703
50 | 45 | 71.868
77 | 76 | 53.84
88 | 56 | 59.645
56 | 90 | 52.50299999999999
84 | 110 | 38.703
112 | 130 | 24.90300000000001
Variable B | Variable A | Sullution |  | Factor a
80 | 100 | 47.513
90 | 90 | 45.53299999999999
65 | 98 | 53.968
76 | 87 | 51.79000000000001
70 | 67 | 58.308
60 | 60 | 63.773
55 | 90 | 59.63799999999999
50 | 80 | 63.703
45 | 50 | 71.868
76 | 77 | 53.84
56 | 88 | 59.645
90 | 56 | 52.50299999999999
110 | 84 | 38.703
130 | 112 | 24.90300000000001
 |  |  |  | Solution - A*a-B*b
Value A*factor a | Value B*factor b | Solution |  | Variable c
 |  | 47.513
 |  | 45.53299999999999
 |  | 53.968
 |  | 51.79000000000001
 |  | 58.308
 |  | 63.773
 |  | 59.63799999999999
 |  | 63.703
 |  | 71.868
 |  | 53.84
 |  | 59.645
 |  | 52.50299999999999
 |  | 38.703
 |  | 24.90300000000001
 |  | Solution |  | Formulae
 |  | 47.513
 |  | 45.53299999999999
 |  | 53.968
 |  | 51.79000000000001
 |  | 58.308
 |  | 63.773
 |  | 59.63799999999999
 |  | 63.703
 |  | 71.868
 |  | 53.84
 |  | 59.645
 |  | 52.50299999999999
 |  | 38.703
 |  | 24.90300000000001
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: LLO

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
LLO001 | 2011-08-01 00:00:00 | CH [NAME] | 94950354 | 750 | 324 |  |  | 2011-08-04 00:00:00 | 05:00:00 | Alsip, IL | 2011-08-06 00:00:00 | 6:00 - 14:00 | Hudson, WI | 5 | 843530
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: December

Employee Absence Schedule
December | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 798660d1664622346-adding-sequence-date-every-11-rows-decapolis-1st-week-com-parison-sheet
Sheet: 20-9-2022

 |  | 2022-09-20 00:00:00 |  |  | Distrbuited by [NAME] |  |  | Difference |  |  | %
 | Date | Destination | #of Meal Deliveed  by [NAME] | Original Request by WFP | [NAME] | [NAME] | Apple | [NAME] | [NAME] | Apple | [NAME] | [NAME] | Apple
 | 2022-09-20 00:00:00 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-09-20 00:00:00 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-09-20 00:00:00 | [NAME] 1st Kitchen | 9341 | 10000
 | 2022-09-20 00:00:00 | [NAME] 2nd Kitchen | 9558 | 8674 | 5030
 | 2022-09-20 00:00:00 | [NAME] | 9109 | 6897
 | 2022-09-20 00:00:00 | Bla'ama  Kitchen | 0 | 0 | 0 | 0 | 0
 | 2022-09-20 00:00:00 | [NAME] | 12963 | 13382
 | 2022-09-20 00:00:00 | South Shouneh Kitchen | 8594 | 8674
 | 2022-09-20 00:00:00 | Naqe’ -Karak Kitchen | 6395 | 6385
 | 2022-09-20 00:00:00 | [NAME] | 4803 | 7183 |  |  | 6650
 | 2022-09-20 00:00:00 | Umm Jmmal Kitchen | 7453 | 4843
 |  | Total | 68216 | 304
Spreadsheet: 849082d1699630429-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments
Sheet: Payment forecast 

 |  |  | Purchase  Month |  |  |  |  |  |  |  | Credit Terms |  |  | Item | Payment Month
 |  |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 60 days | 30 days | Due Now |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 0.25 | 0.6 | 0.15 | Stock & Purchase - PT A |  |  |  |  |  | ???? | ??? | ????
 |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.5 | 0.3 | Stock & Purchase - PT B
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T35

الجدول 35: النسبة المئوية للأولاد (0-14) سنة، خلال سنوات التعداد
Table 35: Percentage of children (0-14) years, during the census years
Country | Round 2000           دورة 2000 |  |  |  | Round 2010           دورة 2010 |  |  |  | البلد
 | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال | Census year سنة التعداد | % Male child نسبة الذكور الأطفال | % Female child  نسبة الإناث الأطفال | % Total child  نسبة المجموع الأطفال
Bahrain | 2001 | 14.25383182396665 | 13.62318706924642 | 27.87701889321307 | 2010 | 10.26210724211082 | 9.793685417849602 | 20.05579265996042 | البحرين
Egypt | 1996 | 19.43505591379307 | 18.23885773003835 | 37.67391364383143 | 2006 | 19.44698650098362 | 18.23752747124733 | 37.68451397223095 | مصر
Iraq | 1997 | 22.81122807132136 | 22.06876146340392 | 44.87998953472528 | ... | ... | ... |  | العراق
Jordan | 2004 | 19.11248033021144 | 18.18112527159542 | 37.29360560180687 | ... | ... | ... |  | الأردن
Kuwait | 1995 | 15.3209314724195 | 14.60449234245384 | 29.92542381487335 | 2011 | 11.70964006719181 | 10.96475691896211 | 22.67439698615392 | الكويت
Lebanon | ... | ... | ... | ... | ... | ... | ... |  | لبنان
Oman | 2003 | 17.25766453137048 | 16.57239038539996 | 33.83005491677044 | 2010 | 14.2186401988261 | 13.6105591569289 | 27.82919935575499 | عمان
Palestine | 1997 | 24.10256646790964 | 22.91325299259821 | 47.01581946050785 | 2007 | 22.0894682187741 | 21.28450456392631 | 43.37397278270042 | فلسطين
Qatar | 2004 | 11.44659683963932 | 11.08182611161662 | 22.52842295125593 | 2010 | 7.01056527610647 | 6.6753950577692 | 13.68596033387567 | قطر
Saudi Arabia | 2004 | 17.11816805009132 | 17.21534921856005 | 34.33351726865136 | ... | ... | ... |  | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | 2008 | 22.26813578723666 | 20.34205783295862 | 42.61019362019528 | السودان
Syrian Arab Republic | 2004 | 20.21430963277152 | 19.01439892845184 | 39.22870856122335 | ... | ... | ... |  | الجمهورية العربية السورية
United Arab Emirates | 1995 | 13.57890637280743 | 12.73313062697814 | 26.31203699978557 | 2005 | 10.12117706808531 | 9.342277140850381 | 19.46328402666805 | الإمارات العربية المتحدة
Yemen | 2004 | 23.27615202131189 | 21.73985775376691 | 45.0160097750788 | ... | ... | ... |  | اليمن
Spreadsheet: 881694d1729839302-data-driven-from-prime-data-to-abstract-as-requires-requet-formula
Sheet: Abs

This is the master data -(A)
Item No | Description of work | BOQ QTY | Qty | Perday Output | Actual Duration | Rounded Duration | Planned Start | Planned Finish | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
1 | [NAME] 1:4 | 35 | M3 | 10 |  |  | 2024-10-16 00:00:00
2 | [NAME] 1:6 | 75 | M3 | 20 |  |  | 2024-10-19 00:00:00
3 | RCC 1:2:4 | 55 | M3 | 25 |  |  | 2024-10-22 00:00:00
 | Work Items | Qty |  | One Day Output |  |  | Start | Finish | Material Constant For 1 Unit of the work Items
Total Quantity Statement Drived from Above Given data (B)
 |  |  |  |  |  |  |  |  | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
 |  |  |  |  |  |  |  | Total Qty
Material Requirement Date wise as described as per above data( C )
Sl.No. | Material Description |  |  |  |  | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks | For Item -1 |  |  |  |  |  | 4940 | 4940
2 | Bricks | For Item -2
Lookup the Start Date and  Duration of the activity  Consumed Quantity of that period to be ABSTRACTED  As per timeline Direct Formula by skipping Step B and Step C
Sl.No. | Material Description | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks |  | 4940 | 4940 | 4940
2 | Cement
3 | Fine Sand
4 | Mason
5 | Helper
6 | W-Helper
7 | Stone aggregate 20mm
8 | Stone aggregate 10mm
9 | Sand
10 | Mixer
11 | Vibrator