tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774989d1648751036-excel-formula-calculation-excel-help
Sheet: Sheet1

Current Month
January | September | October | November | December | January | February | March | April | May | June | July | August
 | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals
Personnel | 14905.95 | 0 | 15456.02 | 15456.01 | 15456.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fringe Benefits | 4521.360000000001 | 0 | 4606.319999999999 | 4640.94 | 4676.629999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub-Total Personnel Expense |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | blue section should show -100% difference from prior month
 |  | yellow section should show 0% because no data and because current month isJan
Spreadsheet: 200268d1355481071-pivot-table-refresh-vba-code-test1
Sheet: Sheet1

 | Fruits | Dealer | Stage | Total Quantity (Kilos)
 | Mango | Dealer 1 | Stage 1 | 5
 | Mango | Dealer 1 | Stage 1 | 6
 | Mango | Dealer 2 | Stage 2 | 8
 | Mango | Dealer 2 | Stage 2 | 2
 | Mango | Dealer 2 | Stage 2 | 1
 | Mango | Dealer 1 | Stage 3 | 1
 | Apple | Dealer 1 | Stage 2 | 2
 | Apple | Dealer 3 | Stage 3 | 2
 | Apple | Dealer 3 | Stage 3 | 2
 | [NAME] | Dealer 2 | Stage 3 | 25
 | [NAME] | Dealer 1 | Stage 3 | 5
 | [NAME] | Dealer 1 | Stage 2 | 5
 | Chickoo | Dealer 2 | Stage 1 | 5
 | Chickoo | Dealer 1 | Stage 1 | 6
Spreadsheet: 728352d1618414818-index-and-match-to-return-a-date-based-on-a-ranked-day-of-the-week-index-match-date-based-on-day-of-the-week-rank-my-solution
Sheet: Sheet1

 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-17 00:00:00 | 2021-04-18 00:00:00 | 2021-04-19 00:00:00 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00
 | Thu | Fri | Sat | Sun | Mon | Tue | Wed |  | Large | Large Occurences | Returned Date | Returned Date based on rank
 | 3 | 2 | 1 | 1 | 0 | 3 | 3 |  |  |  |  |  | 2021-04-15 00:00:00
 | 28 | 28 | 3 | 4 | 11 | 15 | 19 |  |  |  |  |  | 2021-04-16 00:00:00
 | 20 | 15 | 7 | 22 | 29 | 29 | 19 |  |  |  |  |  | 2021-04-19 00:00:00
Spreadsheet: 700064d1602931939-looking-up-multiple-columns-in-a-nestled-if-film-club-2020-1-
Sheet: Info

Total Number of Films
Total Film Time
Average Film Length
Longest Film
Shortest Film
Average Year
Oldest Film
Newest Film
Total Oscars
Total Oscar Nominations
Passed Bechdel Test
Based On A True Story
Spreadsheet: 814219d1674229713-look-up-same-requirements-output-different-results-automated-schedule-help-example
Sheet: Workers

Date | Activity | Results |  |  | Notes
2023-04-01 00:00:00 | Work |  |  |  | This is to build an automated schedule. The "Work, Work, and Help" all start on the same day.  I would like C2,C3, and C4 to display the person from the "schedule" sheet in row C into the corrosponding activity. For example C2,C3, and C4 would all reference A2.  C5,C6,C7 would all reference A5  C8, C9, C10 would all reference A7
2023-04-02 00:00:00 | Work
2023-04-03 00:00:00 | Help
2023-04-04 00:00:00 | Work
2023-04-05 00:00:00 | Work
2023-04-06 00:00:00 | Help
2023-04-07 00:00:00 | Work
2023-04-08 00:00:00 | Work
2023-04-09 00:00:00 | Help
Expected Results
Date | Activity | Results
2023-04-01 00:00:00 | Work | [NAME]
2023-04-02 00:00:00 | Work | [NAME]
2023-04-03 00:00:00 | Help | [NAME]
2023-04-04 00:00:00 | Work | [NAME]
2023-04-05 00:00:00 | Work | [NAME]
2023-04-06 00:00:00 | Help | Cameron
2023-04-07 00:00:00 | Work | [NAME]
2023-04-08 00:00:00 | Work | Helen
2023-04-09 00:00:00 | Help | [NAME]
Spreadsheet: 881000d1728903439-condit-formatting-and-lookup-student-shop
Sheet: Sheet1

ITEM | PRICE | Opening  Stock | Stock purchased | Stock balance | Sales-to- Date Value | ITEM PURCHASED | NO. SOLD | Sales Value | STUDENT | DATE | ITEM GIVEN
[NAME] | 12.6 | 6 | 12 |  |  | [NAME] | 3
[NAME] Matte Foundation Pallette | 45.3 | 2 |  |  |  | [NAME] | 1
Mehron Paradise AQ Pallette Basic | 26.4 | 3 |  |  |  | Mehron Olive Mask Cover | 12
[NAME] Colours | 24.9 | 3 |  |  |  | [NAME] 00 A&B | 1
Mehron Brights Mask Cover | 16.32 | 2
Mehron Olive Mask Cover | 16.32 | 24
[NAME] Powders | 25 | 4
Nose & Scar Wax  Fair 1oz | 6 | 4
[NAME] | 35 | 2
[NAME] (8 shades) | 35 | 2
[NAME] Airbush Tattoo Cover Kit | 20 | 4
[NAME] 00 A&B | 37 | 1
[NAME] 10 A&B | 37 | 4
[NAME] A&B | 37 | 0
[NAME] Brush Set | 40 | 2
0.4mm Airbrush Nozzles
0.4mm Airbrush Needles
[NAME] | 34.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERALL TOTAL
Spreadsheet: 85345d1285353167-sum-calculations-for-university-datah2
Sheet: T3

U.S. goods exported to China | bUSD
Aircraft and spacecraft | 2.32
Data processing and office machines | 0.7
Electrical machinery and appliances | 1.25
Fertilizers | 0.93
Industrial machinery | 0.68
Plastics | 0.3
Power-generating equipment | 0.49
Scientific instruments | 0.46
Specialized industrial machinery | 0.48
Telecommunications and audio equipment | 0.54
Others | 4.34
U.S. imports from China | bUSD
Apparel and clothing accessories | 7.36
Data processing and office machines | 8.26
Electrical machinery and appliances | 7.06
Footwear | 8.43
Furniture and bedding | 3.26
Metals | 2.89
Plumbing, heating, and lighting fixtures | 2.07
Telecommunications and audio equipment | 7.5
Toys, games, and sporting goods | 11.64
Travel goods and handbags | 1.97
Others | 21.35
Spreadsheet: 1024a41f-3489-4a3e-a460-f4bdeb1d5bd5
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 3/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.50195271570364 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.18290210294554 | -1.710578956392525 | 53.47232314655302
 | [NAME] | 39.68639703314219 | 0.4116515212131603 | 0.1556294004142207 | 0.2911846112394774 | 40.54486256600905 | -0.07359084686626552 | 40.47127171914278
 | [NAME] | 18.15775402767459 | 0.3276752205139929 | 0.1724812688977974 | 0.262850502262973 | 18.92076101934935 | -1.653072499503316 | 17.26768851984604
 | [NAME] | 11.45222355578417 | 0.1001822534656735 | 0.5687614475406668 | 0.6743722960217218 | 12.79553955281223 | 5.569390126742816 | 18.36492967955505
 | MY Sep-Aug | 121.7983273323046 | 3.1178170226007 | 0.9302710396612208 | 1.597649846549658 | 127.4440652411162 | 2.132147823980709 | 129.5762130650969 | 92.37017534250782 | 1.402792758426942
2011/12 | Q1 Sep-Nov | 46.36464663783633 | 1.125526280695738 | -0.04624466235028046 | 0.33730317487533 | 47.78123143105712 | -0.4361019712222776 | 47.34512945983484
 | [NAME] | 39.18632400475002 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594563 | 39.83022486394493 | 1.192639826691378 | 41.02286469063631
 | [NAME] | 21.78890349456733 | 0.3898827100518819 | 0.02449399488891973 | 0.2052333688042665 | 22.40851356831239 | -1.866224686136671 | 20.54228888217572
 | [NAME] | 8.177732055653985 | 0.1344738463101611 | 0.9865092519261807 | 0.7466332096840184 | 10.04534836357435 | 11.66404036610358 | 21.70938872967793
 | MY Sep-Aug | 115.5176061928077 | 1.794567957681634 | 1.23562950927642 | 1.517514567123071 | 120.0653182268888 | 10.55435353543601 | 130.6196717623248 | 92.61411956668705 | 1.410364557515139
2012/13 | Q1 Sep-Nov | 52.40512341798276 | 2.020460650397211 | 0.0766389884524422 | 0.3755791242217488 | 54.87780218105416 | -0.5259405013648598 | 54.35186167968931
 | MY Sep-Aug | 115.5753684758657 | 2.286106189632509 | 1.210255907815488 | 1.625936623998694 | 120.6976671973124 | 8.067233294415098 | 128.7649004917275 | 91.7544076555504 | 1.403364740526863
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 3/10/2013
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: BudgetResourceDays

 | [NAME]? | Rate |  |  |  | 2011 |  |  |  |  |  |  |  |  | 2012 |  |  | Y1 | Y1 | 2012 |  |  |  |  |  |  |  |  | 2013 |  |  | Y2 | Y2 | 2013 |  |  |  |  |  |  |  |  | 2014 |  |  | Y3 | Y3
 |  |  |  |  |  | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | A | M | J | J | A | S | O | N | D | J | F | M | TOTAL | TOTAL | TOTAL | TOTAL
ACTIVITIES & TIMELINE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST |  |  |  |  |  |  |  |  |  |  |  |  | DAYS | COST | DAYS | COST
WBC - BDO1 | Int | 0
WBC - BDO2 | Int | 0
WBC - BDO3 | Int | 0
WBC - BDO4 | Int | 0
WBC - BDO5 | Int | 0
WBC - PM1 | Int | 0
WBC - PM2 | Int | 0
WBC - PM3 | Int | 0
WBC - PM4 | Int | 0
WBC - Infrastructure1 | Int | 0
WBC - Infrastructure2 | Int | 0
WBC - Infrastructure3 | Int | 0
WBC - Security/Networks1 | Int | 0
WBC - Security/Networks2 | Int | 0
WBC - HelpDesk1 | Int | 0
WBC - HelpDesk2 | Int | 0
WBC - Webmaster | Int | 0
WBC - Web Developer1 | Int | 0
WBC - Web Developer2 | Int | 0
WBC - Telecomms1 | Int | 0
WBC - Telecomms2 | Int | 0
WBC - AN Other1 | Int | 0
WBC - AN Other2 | Int | 0
WBC - AN Other3 | Int | 0
WBC - AN Other4 | Int | 0
Supplier1 - PM | Ext | 700
Supplier1 - BA | Ext | 500
Supplier2 - PM | Ext | 1000
Supplier2 - Other | Ext | 700
Supplier3 - PM | Ext | 800
Supplier3 - Other | Ext | 500
Supplier4 - PM | Ext | 900
Supplier4 - Other | Ext | 600
Supplier5 - PM | Ext | 600
Supplier5 - Other | Ext | 400
Supplier6 - PM | Ext | 500
Supplier6 - Other | Ext | 400
Supplier7 - PM | Ext | 1000
Supplier7 - Other | Ext | 750
Supplier8 - PM | Ext | 600
Supplier8 - Other | Ext | 400
Supplier9 - PM | Ext | 700
Supplier9 - Other | Ext | 400
Consultant1 | Ext | 600
Consultant2 | Ext | 600
Consultant3 | Ext | 700
Consultant4 | Ext | 900
Consultant5 | Ext | 500
Consultant6 | Ext | 700
Consultant7 | Ext | 600
Consultant8 | Ext | 500
Consultant9 | Ext | 500
Consultant10 | Ext | 700
Other1 | Ext | 500
Other2 | Ext | 500
Other3 | Ext | 500
Other4 | Ext | 700
Other5 | Ext | 500
Other6 | Ext | 500
Other7 | Ext | 500
Other8 | Ext | 700
Other9 | Ext | 500
Other10 | Ext | 500
Other11 | Ext | 500
Other12 | Ext | 500
Other13 | Ext | 500
Other14 | Ext | 500
Other15 | Ext | 500
Other16 | Ext | 500
. | Int | 0
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Extra Hardware/Software
Total Int Resource Days
Total Ext Resource Days
Spreadsheet: 881494d1729569648-creating-scheduling-spreadssheet-help-needed-shift_schedule_corrected-1-
Sheet: Shift Schedule

Employee Name | Shift | Mon AM | Mon PM | Tue AM | Tue PM | Wed AM | Wed PM | Thu AM | Thu PM | Fri AM | Fri PM | Sat AM | Sat PM | Sun AM | Sun PM
Employee 1 | AM | Y |  | N |  | Y |  | Y |  | N |  | N |  | Y
Employee 2 | PM |  | N |  | Y |  | N |  | Y |  | Y |  | N |  | Y
Employee 3 | Both | Y | Y | Y | Y | N | N | N | N | Y | Y | Y | Y | N | N
Employee 4 | AM | N |  | N |  | Y |  | N |  | N |  | Y |  | N
Employee 5 | AM | Y |  | Y |  | Y |  | Y |  | Y |  | N |  | N
Employee 6 | AM | Y |  | Y |  | Y |  | Y |  | Y |  | N |  | N
Employee 7 | PM |  | Y |  | Y |  | Y |  | Y |  | Y |  | Y |  | Y
Employee 8 | PM |  | N |  | Y |  | N |  | Y |  | Y |  | N |  | Y
Spreadsheet: 149453d1333978477-how-to-use-data-validation-drop-down-menu-with-another-cell-block-example-2-
Sheet: Sheet1

 | A
 | C
 | B
 | D
 | F
 | E
 | G
 | H
 | J
 | I
 | K
 | L
Spreadsheet: 82601d1282662855-filter-data-and-auto-display-test
Sheet: Sheet1

Part No | Quantity | Price
1012 | 500
Description | Part Number | 0 | 200 | 600 | 1000 | 1500
Part 1 | 1001 | 2.5 | 2.25 | 2 | 1.75 | 1.5
Part 2 | 1002 | 3.5 | 3.25 | 3 | 2.75 | 2.5
Part 3 | 1003 | 4.5 | 4.25 | 4 | 3.75 | 3.5
Part 4 | 1004 | 5.5 | 5.25 | 5 | 4.75 | 4.5
Part 5 | 1005 | 6.5 | 6.25 | 6 | 5.75 | 5.5
Part 6 | 1006 | 7.5 | 7.25 | 7 | 6.75 | 6.5
Part 7 | 1007 | 8.5 | 8.25 | 8 | 7.75 | 7.5
Part 8 | 1008 | 9.5 | 9.25 | 9 | 8.75 | 8.5
Part 9 | 1009 | 10.5 | 10.25 | 10 | 9.75 | 9.5
Part 10 | 1010 | 11.5 | 11.25 | 11 | 10.75 | 10.5
Part 11 | 1011 | 12.5 | 12.25 | 12 | 11.75 | 11.5
Part 12 | 1012 | 13.5 | 13.25 | 13 | 12.75 | 12.5
Part 13 | 1013 | 14.5 | 14.25 | 14 | 13.75 | 13.5
Part 14 | 1014 | 15.5 | 15.25 | 15 | 14.75 | 14.5
Part 15 | 1015 | 16.5 | 16.25 | 16 | 15.75 | 15.5
Spreadsheet: 72423d1273096406-returning-values-from-multiple-sheets-using-multiple-searches-music2010sales
Sheet: Apr2010Sales

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2010-04 | 2 | 0.71 | 1.42 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | GB
2010-04 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Boobs | iTunes UK/European Union | GB
2010-04 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Funt | iTunes UK/European Union | GB
2010-04 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | DE
Spreadsheet: 544252d1508833807-help-trying-to-link-values-from-one-workbook-to-another-formulas-for-dimensions-of-shited-spur-gears-samp
Sheet: GEAR TRAIN

# | Face [NAME] | Teeth | O.D. | I.D.
2000 | 53 | 49 | 193.125 | 176.25
2001 | 40 | 41 | 161.5 | 145
2002 | 40 | 51 | 199.25 | 182.5
0013 | 46 | 41 | 159.5 | 145
0016 | 35.25 | 32 | 126 | 110.8
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 1.3

Cuadro 1.3
[NAME]
Nacimientos ocurridos por grupo de edad del padre, según grupo de edad de la madre al momento del nacimiento del hijo (a), 2010
Grupos de edad de la madre al momento del nacimiento del hijo (a) | Total | Grupos de edad del padre al momento del nacimiento del hijo (a)
 |  | Menor de 15 años | 15-19 | 20-24 | 25-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50 años y más | No especificada
Total país
Menor de 15 años |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15-19 |  | 4 | 1146 | 6126 | 3927 | 1592 | 724 | 347 | 169 | 164 | 2544
20-24 |  | 3 | 578 | 8875 | 12001 | 6826 | 2883 | 1425 | 715 | 598 | 5104
25-29 |  | 3 | 161 | 2722 | 8988 | 9351 | 4534 | 2169 | 1016 | 776 | 3374
30-34 |  | 4 | 40 | 811 | 2815 | 6244 | 4802 | 2335 | 1076 | 832 | 1901
35-39 |  | 1 | 22 | 192 | 666 | 1447 | 2332 | 1597 | 821 | 607 | 827
40-44 |  | 0 | 2 | 43 | 109 | 188 | 318 | 479 | 275 | 190 | 184
45-49 |  | 0 | 0 | 5 | 7 | 13 | 15 | 26 | 30 | 27 | 21
50 años y más |  | 0 | 0 | 2 | 4 | 3 | 3 | 5 | 1 | 12 | 0
No especificado |  | 0 | 36 | 121 | 110 | 65 | 39 | 21 | 14 | 10 | 564
Nota: Elaborado con datos registrados en las Oficialías del Estado Civil. Junta Central Electoral.
Fuente: Oficina Nacional de Estadística, (ONE).
Spreadsheet: theresa_staab__39597__Producer Pricing Detail Nov01
Sheet: Internal Kennedy Total

FOR INTERNAL USE ONLY
June NGPL Midcont.:
June CIG: |  |  |  |  |  | Pro-Rata Production
First of Month Nomination: |  | 21032 |  |  |  | [NAME]
Additional Purchases: |  | 21893 |  |  |  | South Kitty
Wt. Avg. Btu: |  |  | [NAME] |  | Nom.
Wt. Avg. Btu: |  |  | [NAME] |  | Nom. |  | 0.3194301458809458
Transportation |  | per Mmbtu | [NAME] |  |  |  | 0.6805698541190542
Transportation |  | per Mmbtu | [NAME]
 |  | 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 Mcf @ CIG GD +.10 | Add'l CIG MMBtu | Additional @ CIG GD -Daily Discount | Add'l CIG GD MMBtu | [NAME] net [NAME] | South Kitty net [NAME] | Total Purchased [NAME] | Box Draw % of Total | South Kitty % of Total |  |  | FOM CIG GD Volume MMBtu | NGPL Volume MMBtu | FOM CIG Volume MMBtu | Add'l CIG GD +.10 MMBtu | Add'l CIG GD - Daily Discount MMBtu | Total Purchased [NAME]
 | CIG GD Rockies ($/MMBtu) | FOM CIG GD less Netback |  | NGPL less Netback |  | FOM CIG less Netback |  | Add'l CIG less Netback |  | Add'l CIG GD less Netback
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Weighted Average
Total Weighted Average Netback
*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: 777433d1650378479-help-with-multiple-dates-and-values-to-count-occurrences-ohio-river-flood-crest-date-info-excelforum-
Sheet: Crests

high  rank | date recent  rank
16 | 1 | 46.12 | ft | 2021-03-07 00:00:00
26 | 2 | 44.53 | ft | 2020-02-17 00:00:00
24 | 3 | 44.91 | ft | 2019-02-28 00:00:00
15 | 4 | 46.45 | ft | 2019-02-15 00:00:00
7 | 5 | 50.68 | ft | 2018-02-27 00:00:00
35 | 6 | 42.97 | ft | 2015-12-30 00:00:00
38 | 7 | 42.3 | ft | 2015-04-18 00:00:00
12 | 8 | 47.33 | ft | 2015-03-17 00:00:00
8 | 9 | 49.3 | ft | 2011-04-28 00:00:00
21 | 10 | 45.32 | ft | 2011-03-15 00:00:00
42 | 11 | 41.5 | ft | 2010-05-07 00:00:00
22 | 12 | 45.04 | ft | 2008-03-22 00:00:00
18 | 13 | 46.05 | ft | 2005-01-14 00:00:00
32 | 14 | 43.55 | ft | 2004-01-09 00:00:00
41 | 15 | 41.56 | ft | 2003-02-28 00:00:00
34 | 16 | 43.25 | ft | 2002-03-25 00:00:00
25 | 17 | 44.69 | ft | 2000-02-22 00:00:00
5 | 18 | 52.42 | ft | 1997-03-08 00:00:00
29 | 19 | 44.3 | ft | 1996-05-13 00:00:00
19 | 20 | 46.03 | ft | 1996-01-27 00:00:00
28 | 21 | 44.32 | ft | 1995-05-23 00:00:00
37 | 22 | 42.5 | ft | 1994-04-20 00:00:00
30 | 23 | 44.1 | ft | 1994-03-16 00:00:00
27 | 24 | 44.52 | ft | 1994-02-01 00:00:00
39 | 25 | 42.04 | ft | 1993-03-10 00:00:00
14 | 26 | 46.85 | ft | 1991-01-05 00:00:00
23 | 27 | 45 | ft | 1990-12-25 00:00:00
31 | 28 | 43.63 | ft | 1990-02-17 00:00:00
17 | 29 | 46.08 | ft | 1989-02-21 00:00:00
36 | 30 | 42.51 | ft | 1985-12-04 00:00:00
20 | 31 | 45.85 | ft | 1984-05-12 00:00:00
9 | 32 | 49.08 | ft | 1978-12-15 00:00:00
40 | 33 | 41.94 | ft | 1977-04-11 00:00:00
33 | 34 | 43.5 | ft | 1976-02-23 00:00:00
13 | 35 | 46.9 | ft | 1972-04-21 00:00:00
43 | 36 | 41.2 | ft | 1971-02-25 00:00:00
44 | 37 | 41.2 | ft | 1971-02-25 00:00:00
3 | 38 | 53.9 | ft | 1964-03-08 00:00:00
11 | 39 | 48.8 | ft | 1962-03-06 00:00:00
6 | 40 | 51.3 | ft | 1948-04-20 00:00:00
2 | 41 | 54.4 | ft | 1945-03-08 00:00:00
10 | 42 | 48.9 | ft | 1943-03-24 00:00:00
1 | 43 | 60.8 | ft | 1937-01-27 00:00:00
4 | 44 | 53.8 | ft | 1913-04-01 00:00:00
Spreadsheet: darrell_schoolcraft__7413__TW Jan02pnr
Sheet: Astra 500621

 | [NAME]
 | INVOICE DETAIL - July, 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | Astra Power | 27502 | 2001-07-01 00:00:00 | 500621 | PnR |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.1
2 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
3 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
4 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
5 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
6 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
7 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
8 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 686089d1594356688-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training
Sheet: Training 2

 | Training 2
 |  |  | 7:30am | 7:30am | 8:00am | 8:00am | 8:30am | 8:30am | 8:30am | 8:30am | 9:00am | 9:30am | 9:30am | 10:00am | 10:00am | 10:00am | 10:00am | 10:00am | 10:30am | 11:00am | 11:00am | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 1:00pm | 1:30pm | 1:30pm | 1:30pm | 2:00pm
 | # of Sessions |  | 1
 | # of Expected on Training Day |  | 1 | 3 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | # [NAME] |  | 1 |  | 2 | 1 | 3 | 3 | 2 | 2 | 2 | 1 |  |  |  | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | New Hire Show Rate
 | [NAME] | The same for training 1-6
 | C6: | Count Row 6 from column D and over, Only the cells with data entered in them
 | C7: | Sum of row 7 tfrom Column D and over "IF" Row 8 has data enetered
 | C8: | Sum of Row 8 from Column D and over
 | Column D and Over: | Manually entered.
Spreadsheet: 803964d1667825991-extracting-data-from-excel-tables-sales-control
Sheet: Cask

 | Cash
 | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 200
 | 2022-11-05 00:00:00 | Abi | A002 | Sales |  | 70 | 250
 | 2022-11-06 00:00:00 | Bigboy | A003 | Sales |  | 71 | 2000
 | 2022-11-06 00:00:00 | Rose | A001 | Sales |  | 72 | 3500
 | 2022-11-07 00:00:00 | Abi | A002 | Sales |  | 80 | 250
 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300
 | 2022-11-07 00:00:00 | Rose | A001 | Sales |  | 30 | 5000
 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000
 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500
 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300
 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000