tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 62309 | 62102
2 | 50220 | 49280
3 | 49998 | 49280
4 | 47950 | 54280
5 | 57018 | 58244
6 | 38266 | 38499
7 | 39789 | 41226
8 | 47049 | 45381
9 | 33373 | 31588
10 | 40278 | 35729
11 | 33622 | 33099
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 9003
2002-03-11 00:00:00
CBS Volume
 |  |  | 4076
Spreadsheet: 180259d1347544545-pivot-table-monthly-running-total-on-a-percentage-toto
Sheet: Feuil1

My data for the [NAME] table :
Source | Month | New Customers | Target |  |  |  | Month
A | 2012-01-01 00:00:00 | 11 | 20 |  | Source | Valeurs | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | Total général
A | 2012-02-01 00:00:00 | 29 | 20 |  | A | New Customers | 14 | 15 | 25 | 2 | 56
A | 2012-03-01 00:00:00 | 17 | 20 |  |  | Target | 20 | 20 | 20 | 20 | 80
A | 2012-04-01 00:00:00 | 29 | 20 |  |  | Success Rate2 | 0.7 | 0.75 | 1.25 | 0.1 | 0.7
B | 2012-01-01 00:00:00 | 2 | 20 |  |  | New Customers Running Total | 14 | 29 | 54 | 56
B | 2012-02-01 00:00:00 | 23 | 20 |  |  | Target Running Total | 20 | 40 | 60 | 80
B | 2012-03-01 00:00:00 | 19 | 20 |  |  | Success Rate Running percent | 0.7 | 0.75 | 1.25 | 0.1 | 0.7
B | 2012-04-01 00:00:00 | 30 | 20 |  | B | New Customers | 20 | 17 | 19 | 13 | 69
C | 2012-01-01 00:00:00 | 13 | 20 |  |  | Target | 20 | 20 | 20 | 20 | 80
C | 2012-02-01 00:00:00 | 16 | 20 |  |  | Success Rate2 | 1 | 0.85 | 0.95 | 0.65 | 0.8625
C | 2012-03-01 00:00:00 | 22 | 20 |  |  | New Customers Running Total | 20 | 37 | 56 | 69
C | 2012-04-01 00:00:00 | 15 | 20 |  |  | Target Running Total | 20 | 40 | 60 | 80
D | 2012-01-01 00:00:00 | 22 | 20 |  |  | Success Rate Running percent | 1 | 0.85 | 0.95 | 0.65 | 0.8625
D | 2012-02-01 00:00:00 | 28 | 20 |  | C | New Customers | 15 | 8 | 20 | 1 | 44
D | 2012-03-01 00:00:00 | 1 | 20 |  |  | Target | 20 | 20 | 20 | 20 | 80
D | 2012-04-01 00:00:00 | 20 | 20 |  |  | Success Rate2 | 0.75 | 0.4 | 1 | 0.05 | 0.55
 |  |  |  |  |  | New Customers Running Total | 15 | 23 | 43 | 44
 |  |  |  |  |  | Target Running Total | 20 | 40 | 60 | 80
 |  |  |  |  |  | Success Rate Running percent | 0.75 | 0.4 | 1 | 0.05 | 0.55
 |  |  |  |  | D | New Customers | 7 | 6 | 6 | 9 | 28
 |  |  |  |  |  | Target | 20 | 20 | 20 | 20 | 80
 |  |  |  |  |  | Success Rate2 | 0.35 | 0.3 | 0.3 | 0.45 | 0.35
 |  |  |  |  |  | New Customers Running Total | 7 | 13 | 19 | 28
 |  |  |  |  |  | Target Running Total | 20 | 40 | 60 | 80
 |  |  |  |  |  | Success Rate Running percent | 0.35 | 0.3 | 0.3 | 0.45 | 0.35
 |  |  |  |  | Total  New Customers |  | 56 | 46 | 70 | 25 | 197
 |  |  |  |  | Total  Target |  | 80 | 80 | 80 | 80 | 320
 |  |  |  |  | Total  Success Rate2 |  | 0.7 | 0.575 | 0.875 | 0.3125 | 0.615625
 |  |  |  |  | Total  New Customers Running Total |  | 56 | 102 | 172 | 197
 |  |  |  |  | Total  Target Running Total |  | 80 | 160 | 240 | 320
 |  |  |  |  | Total  Success Rate Running percent |  | 0.7 | 0.575 | 0.875 | 0.3125 | 0.615625
Spreadsheet: darrell_schoolcraft__7413__TW Jan02pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary for January, 2002
Billing Month | Buyer | Purchase Order # | POI | BOM BALANCE | Dekatherm | Rate/Dth | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance | System Generated Amount
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.08 |  | Daily
2002-01-01 00:00:00 |  |  |  |  |  | 0.08 |  | Total
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 |  |  |  |  |  | 0.04 |  | Daily
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.05 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 |  |  |  |  |  | 0.02 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.03 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 | TOTALS
 |  |  |  |  |  |  | Average Charge per Dth -
 | Posted Rates During January, 2002
 |  |  | [NAME] |  |  |  |  |  | Ride Rate
 | Point Name: | POI# | Jan. 1 - 31 |  |  |  |  |  | Jan. 1 - 31
 | PNR Needles | 500615 | [NAME] |  |  |  |  |  | [NAME]
 | PNR Topock – PG&E | 500616 | [NAME] |  |  |  |  |  | [NAME]
 | PNR Rio Puerto – PNM | 500617 | 0.1 |  |  |  |  |  | 0.1
 | PNR Central Pool | 500621 | 0.1 |  |  |  |  |  | 0.1
 | PNR West Texas Pool | 500622 | 0.1 |  |  |  |  |  | 0.1
 | PNR Panhandle Pool | 500623 | 0.1 |  |  |  |  |  | 0.1
 | PNR Thoreau | 500624 | [NAME] |  |  |  |  |  | [NAME]
 | PNR Lone Star – (Ward) Del. | 500625 | 0.1 |  |  |  |  |  | 0.1
 | PNR [NAME] | 500626 | 0.1 |  |  |  |  |  | 0.1
 | PNR Valero Ward Co. Del | 500627 | 0.1 |  |  |  |  |  | 0.1
 | PNR Lone Star (Pecos) | 500628 | 0.1 |  |  |  |  |  | 0.1
 | PNR [NAME] | 500629 | 0.1 |  |  |  |  |  | 0.1
 | PNR SW Gas Mohave | 78149 | [NAME] |  |  |  |  |  | [NAME]
 | PNR Citizens Griffith | 78150 | [NAME] |  |  |  |  |  | [NAME]
 | PNR Calpine Southpoint | 78151 | [NAME] |  |  |  |  |  | [NAME]
 | PNR NNG/TW GRAY | 78293 | 0.1 |  |  |  |  |  | 0.1
 | PNR NNG/TW HALLEY | 78294 | 0.1 |  |  |  |  |  | 0.1
 | *[NAME] = $0.3883
Spreadsheet: a1f573d4-53c8-4fa1-b721-0166aad82f1b
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Jan. | Feb. | Mar. | Mar.
Item | 2013 | 2013 | 2013 | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 252843.201 | 233182.734 | 223908.162 | 242921.086
Cotton | 53632.401 | 49718.474 | 44205.009 | 51989.653
Linen | 25325.432 | 17408.625 | 19196.402 | 21000.697
Wool | 3555.503 | 3126.851 | 3246.618 | 3389.626
Silk | 546.943 | 429.056 | 485.868 | 542.11
Manmade | 169782.922 | 162499.728 | 156774.265 | 165999
Apparel: | 889304.1190000001 | 875083.9299999999 | 743937.651 | 731395.024
Cotton | 499298.839 | 499440.142 | 438624.647 | 428684.612
Linen | 9830.58 | 10397.966 | 8142.328 | 9380.834
Wool | 18543.334 | 17178.492 | 14323.305 | 15136.753
Silk | 10045.461 | 10301.503 | 7625.13 | 8615.782
Manmade | 351585.905 | 337765.827 | 275222.241 | 269577.043
Home furnishings: | 214129.219 | 213658.218 | 176400.957 | 173995.144
Cotton | 123562.709 | 123263.348 | 113890.352 | 108380.899
Linen | 920.439 | 864.426 | 639.003 | 630.188
Wool | 402.997 | 315.166 | 308.52 | 304.546
Silk | 146.094 | 174.805 | 137.927 | 144.768
Manmade | 89096.98 | 89040.473 | 61425.155 | 64534.743
Floor coverings: | 66620.488 | 56210.929 | 58000.931 | 57505.64
Cotton | 7884.405 | 6695.796 | 7231.482 | 7337.125
Linen | 18081.768 | 15384.178 | 15354.919 | 15256.777
Wool | 9271.104 | 7792.537 | 9210.195 | 9226.035
Silk | 1618.289 | 1205.358 | 1754.796 | 1648.353
Manmade | 29764.922 | 25133.06 | 24449.539 | 24037.35
Total imports: 2/ | 1423362.61 | 1378474.213 | 1202603.274 | 1206201.169
Cotton | 684611.241 | 679320.418 | 604190.911 | 596652.049
Linen | 54158.219 | 44055.195 | 43332.652 | 46268.496
Wool | 31778.068 | 28420.061 | 27104.647 | 28058.779
Silk | 12356.788 | 12110.723 | 10003.721 | 10951.013
Manmade | 640458.294 | 614567.816 | 517971.343 | 524270.832
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 05/14/13.
Spreadsheet: 129603d1321729704-sensitivity-and-solution-space-solver77-nyc
Sheet: Limits Report 1

Microsoft Excel 14.0 Limits Report
Worksheet: [solver_77 (1).xlsx]Sheet1
Report Created: 11/18/2011 9:59:18 PM
 |  | Objective
 | Cell | Name | Value
 | $F$8 | Total Maximisise chess rating | 1400
 |  | Variable |  |  | Lower | Objective |  | Upper | Objective
 | Cell | Name | Value |  | Limit | Result |  | Limit | Result
 | $B$4 | Chess beginner players Number of players | 7.999999999999996 |  | 7.999999999999996 | 1400 |  | 7.999999999999996 | 1400
 | $B$5 | chess  mediocre players  Number of players | 3.999999999999999 |  | 3.999999999999999 | 1400 |  | 3.999999999999999 | 1400
 | $B$6 | highly advanced chess players Number of players | 8.000000000000004 |  | 8.000000000000004 | 1400 |  | 8.000000000000004 | 1400
Spreadsheet: 2a3424ae-6c73-4d4d-a1cc-046b24ac07f7
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0007143 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Camp Sea Gull | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 5.37 |  | Area (acres): |  | 6.53 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 142 |  | Annual Rate (in): |  | 142 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 194885d1353351650-complex-lookup-functions-causing-slowdown-jobs
Sheet: Magick

hier. | JOB: | MAGICK: | REQ:
6 | [NAME] | Cura | Q50
53 | [NAME] | Raise | Q50
40 | [NAME] | Protectga | Cuchulainn
43 | [NAME] | [NAME] | Cuchulainn
9 | Knight | Curaga | Mateus
11 | Knight | Curaja | Hashmal
24 | Knight | Cleanse | Mateus
27 | Knight | Esuna | Mateus
45 | Knight | Faith | Hashmal
47 | Knight | Bravery | Hashmal
58 | Knight | Regen | Mateus
60 | Knight | Confuse | Hashmal
4 | Monk | Cura | Hashmal
12 | Monk | Curaja | [NAME]
14 | Monk | Renew | Zodiark
29 | Monk | Esunaga | Chaos
33 | Monk | [NAME] | Famfrit
39 | Monk | Protectga | Chaos
42 | Monk | [NAME] | Chaos
48 | Monk | Bravery | [NAME]
51 | Monk | Raise | Hashmal
55 | Monk | Arise | Famfrit
62 | Monk | Holy | Chaos
3 | Red Mage | Cura | None
8 | Red Mage | Curaga | None
17 | Red Mage | Vox | Q50
19 | Red Mage | Poisona | Q50
21 | Red Mage | Stona | None
23 | Red Mage | Cleanse | Shemhazai
26 | Red Mage | Esuna | Shemhazai
31 | Red Mage | Dispel | None
35 | Red Mage | Protect | None
37 | Red Mage | Shell | None
50 | Red Mage | Raise | None
57 | Red Mage | Regen | None
5 | Time Mage | Cura | Adrammelech
52 | Time Mage | Raise | Adrammelech
1 | White Mage | Cure | None
2 | White Mage | Cura | None
7 | White Mage | Curaga | None
10 | White Mage | Curaja | None
13 | White Mage | Renew | None
15 | White Mage | Blindna | None
16 | White Mage | Vox | None
18 | White Mage | Poisona | None
20 | White Mage | Stona | None
22 | White Mage | Cleanse | None
25 | White Mage | Esuna | None
28 | White Mage | Esunaga | None
30 | White Mage | Dispel | None
32 | White Mage | [NAME] | None
34 | White Mage | Protect | None
36 | White Mage | Shell | None
38 | White Mage | Protectga | None
41 | White Mage | [NAME] | None
44 | White Mage | Faith | None
46 | White Mage | Bravery | None
49 | White Mage | Raise | None
54 | White Mage | Arise | None
56 | White Mage | Regen | None
59 | White Mage | Confuse | None
61 | White Mage | Holy | None
Spreadsheet: 684172d1593182767-if-and-not-else-or-help-needed-sample-time-sheet
Sheet: Sheet1

[NAME] |  |  |  |  |  |  | Week Ending Date: |  |  | 2020-06-19 00:00:00
Job Name | Job# OR | Date | TOTAL | 13960 | O/T | PREM | JOB | JOB | 40550 | 40350 | 52500 | 52100 | 52000
 | Acct # |  | HRS | SERVICE |  | O/T |  | OT |  |  | Shop | VAC
River Walk | 13960 | 2020-06-15 00:00:00 | 8 |  | 1.5
Office Meeting | 52000 | 2020-06-16 00:00:00 | 2.5
River Walk | 13960 | 2020-06-16 00:00:00 | 6
River Walk | 13960 | 2020-06-17 00:00:00 | 8
River Walk | 13960 | 2020-06-18 00:00:00 | 7
[NAME] 16D | 13960 | 2020-06-18 00:00:00 | 1
[NAME] 16D | 13960 | 2020-06-19 00:00:00 | 7
River Walk | 13960 | 2020-06-19 00:00:00 | 1
TOTAL
Spreadsheet: jim_schwieger__14299__Bronco Division Rescheduled Games _4
Sheet: Sheet1

Game # | Visitor Team | Home Team | Day | Date | Time | Field | Comments
Bronco-Gray
1102 | Pirates-Hamilton | Marlins-Bleyl | SAT | 2001-05-12 00:00:00 | 10:00am | WLY#5
1144 | Mariners-Bleyl | Twinns-Truitt | FRI | 2001-05-11 00:00:00 | 8:00pm | [NAME]
1167 | Pirates-Hamilton | Braves-Thorton | FRI | 2001-05-11 00:00:00 | 6:00pm | WLY#5
1179 | Cubs-Hamilton | Red Sox-Thorton | FRI | 2001-05-11 00:00:00 | 6:00pm | [NAME]
1146 | Braves-Thorton | Dodgers-Truitt | FRI | 2001-05-11 00:00:00 | 6:00pm | WLY#5
1176 | Marlins-Bleyl | Reds-Laybay | WED | 2001-05-09 00:00:00 | 6:00pm | WLY#5
1177 | Rangers-Dean | Padres-Arnold | FRI | 2001-05-11 00:00:00 | 8:00pm | BC#2
Bronco-Maroon
1217 | Cardinals-Hamilton | Reds-Cook | FRI | 2001-05-11 00:00:00 | 6:00pm | BC#2
1232 | Marlins-Bleyl | Cardinals-Hamilton | WED | 2001-05-09 00:00:00 | 8:00pm | WLY#5
1231 | Astros-Campbell | Braves-Labay | SUN |  |  |  | Awaiting Contact
1218 | A's-Hamilton | Astros-Campbell | FRI |  |  |  | Awaiting Contact
Spreadsheet: 805693d1668838333-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-answer
Sheet: Fund 2

 |  |  |  |  |  | Transaction Links | Dates | 2022-12-31 00:00:00
 |  |  |  |  |  |  | Data Item #1 | 0 | 7.897033991517565 | 0 | 6.013480804520922 | 0 | 4.53544394332155 | 0 | 3.431886901881908
 |  |  |  |  |  |  | Data Item #2 | 22.43017550062175 | 0 | 173.8117556586841 | 0 | 202.6633774997705 | 0 | 267.6713243095267 | 0
 |  |  |  |  |  |  | Data Item #3 | 8.485899289745902 | -0.1362003731834112 | 57.63091617980378 | -0.06897445300892191 | 73.80052705637746 | -2.20400153396699 | 96.91867028270889 | -0.4353141557889346
 |  |  |  |  |  |  | Data Item #4 | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
Spreadsheet: 780986d1652917713-min-custom-message-when-null-daily-tickets-report-beta-
Sheet: Daily Tickets Report

FreshDesk | Open Tickets | Pending Tickets | Oldest Open Response
Total Open
CallTek | Open Tickets |  | Oldest Ticket Age
Tier - 1 (Calltek-Guest)
Tier - 2 (Calltek-NOC)
Tier - 3 (HIS-NOC)
BeyondTV Support
Total Open
Kentrone | Open Tickets |  | Oldest Ticket Age
Tier - 1
Tier - 2
Tier - 3
Total Open
CRM | Open Tickets |  | Oldest Ticket Age
[NAME] |  |  | 2020-07-16 00:00:00
[NAME] |  |  | 2021-08-07 00:00:00
[NAME] |  |  | 2022-02-03 00:00:00
[NAME] |  |  | 2022-03-03 00:00:00
[NAME] |  |  | 2022-03-31 00:00:00
[NAME] [NAME] |  |  | 2022-04-20 00:00:00
[NAME] |  |  | 2022-04-20 00:00:00
[NAME] |  |  | 2022-05-02 00:00:00
[NAME]
[NAME]
[NAME]
Nate Thibault
[NAME]
Total Open
 | DO NOT COPY ZERO ROWS
Spreadsheet: 712973d1610504604-extract-values-text-only-left_right_function_extract_sample
Sheet: Here

# | ID | First Name | Last Name | Name | Cond1 | Letter | First Name | Extract | Outcome
 |  |  |  |  |  |  |  |  | Tbnor, Cadigan
 |  |  |  |  |  |  |  | Tbra, Cadle - AA21259159 | Tbra, [NAME]
 |  |  |  |  |  |  |  | Tbrahame, Cadogan - LB71531251 | Tbrahame, [NAME]
 |  |  |  |  |  |  |  | Tbrahem, Cadwalader - EB32531079 | Tbrahem, [NAME]
 |  |  |  |  |  |  |  |  | Tbnor, Cadigan
Spreadsheet: 158937d1338456042-excel-2007-wins-lose-and-pf-pa-tracker-test
Sheet: Sheet1

Date | Location | Time | Home | Score | Away | Score |  | Team | Place | Wins | Loses | PF | PA
2012-05-22 00:00:00 | Field 8 | 1830 | Cubs | 13 | Tigars | 1 |  | Indians
2012-05-22 00:00:00 | Field 9 | 1830 | Red Sox | 1 | Giants | 22 |  | Blue Jays
2012-05-22 00:00:00 | Field 8 | 1930 | Blue Jays | 12 | Giants | 10 |  | Giants
2012-05-24 00:00:00 | Field 8 | 1830 | Indians | 10 | Blue Jays | 9 |  | White Sox
2012-05-24 00:00:00 | Field 8 | 1930 | White Sox | 6 | Red Sox | 8 |  | Red Sox
2012-05-29 00:00:00 | Field 8 | 1830 | White Sox | 14 | Indians | 8 |  | Tigars
2012-05-29 00:00:00 | Field 9 | 1930 | White Sox | 9 | Tigars | 7 |  | Cubs
2012-05-29 00:00:00 | Field 8 | 1930 | Red Sox | 2 | Cubs | 23
2012-05-31 00:00:00 | Field 9 | 1830 | Indians |  | Red Sox
2012-05-31 00:00:00 | Field 8 | 1930 | Giants |  | Red Sox
2012-05-31 00:00:00 | Field 9 | 1930 | Cubs |  | Indians
2012-06-05 00:00:00 | Field 9 | 1830 | Tigars |  | Red Sox
2012-06-05 00:00:00 | Field 8 | 1830 | Giants |  | White Sox
2012-06-05 00:00:00 | Field 9 | 1930 | Red Sox |  | Blue Jays
2012-06-05 00:00:00 | Field 8 | 1930 | Indians |  | Tigars
2012-06-07 00:00:00 | Field 9 | 1830 | Tigars |  | Giants
2012-06-07 00:00:00 | Field 8 | 1830 | Blue Jays |  | White Sox
2012-06-07 00:00:00 | Field 9 | 1930 | Tigars |  | Blue Jays
2012-06-07 00:00:00 | Field 8 | 1930 | Giants |  | Indians
2012-06-12 00:00:00 | Field 9 | 1830 | Indians |  | White Sox
2012-06-12 00:00:00 | Field 8 | 1830 | Giants |  | Cubs
2012-06-12 00:00:00 | Field 9 | 1930 | Tigars |  | Cubs
2012-06-12 00:00:00 | Field 8 | 1930 | Blue Jays |  | Indians
2012-06-19 00:00:00 | Field 9 | 1830 | Tigars |  | White Sox
2012-06-19 00:00:00 | Field 8 | 1830 | Cubs |  | Red Sox
2012-06-19 00:00:00 | Field 9 | 1930 | Giants |  | Blue Jays
2012-06-19 00:00:00 | Field 8 | 1930 | Tigars |  | Indians
2012-06-26 00:00:00 | Field 9 | 1830 | Red Sox |  | White Sox
2012-06-26 00:00:00 | Field 8 | 1830 | Blue Jays |  | Tigars
2012-06-26 00:00:00 | Field 9 | 1930 | Cubs |  | Giants
2012-06-26 00:00:00 | Field 8 | 1930 | Red Sox |  | Indians
2012-07-10 00:00:00 | Field 9 | 1830 | Cubs |  | Blue Jays
2012-07-10 00:00:00 | Field 8 | 1830 | Red Sox |  | Tigars
2012-07-10 00:00:00 | Field 9 | 1930 | White Sox |  | Giants
2012-07-10 00:00:00 | Field 8 | 1930 | Blue Jays |  | Red Sox
2012-07-12 00:00:00 | Field 9 | 1830 | White Sox |  | Cubs
2012-07-12 00:00:00 | Field 8 | 1830 | Indians |  | Giants
2012-07-12 00:00:00 | Field 9 | 1930 | White Sox |  | Blue Jays
2012-07-12 00:00:00 | Field 8 | 1930 | Indians |  | Cubs
2012-07-17 00:00:00 | Field 8 | 1830 | Giants |  | Tigars
2012-07-17 00:00:00 | Field 9 | 1830 | Cubs |  | White Sox
2012-07-17 00:00:00 | Field 9 | 1930 | Blue Jays |  | Cubs
Spreadsheet: 752375d1634737124-reduce-quantities-stock-quantities-example
Sheet: Sheet1

RAW ORDER DATA |  |  |  |  | RAW BATCH DATA |  |  |  |  | DESIRED OUTPUT:
Stock ID | Order No | [NAME] | Order Date |  | Stock ID | Available | [NAME] |  |  | Stock ID | [NAME] | Order Date | Proposed Allocation | [NAME]
23 | 1 | 100000 | 2021-04-01 00:00:00 |  | 23 | 200000 | 777 |  |  | 23 | 100000 | 2021-04-01 00:00:00 | 100000 | 777
23 | 2 | 150000 | 2021-05-01 00:00:00 |  | 23 | 300000 | 666 |  |  | 23 | 150000 | 2021-05-01 00:00:00 | 100000 | 777
23 | 3 | 50000 | 2021-05-20 00:00:00 |  | 24 | 100000 | 222 |  |  |  |  |  | 50000 | 666
23 | 4 | 25000 | 2021-05-26 00:00:00 |  | 25 | 50000 | 999 |  |  | 23 | 50000 | 2021-05-20 00:00:00 | 50000 | 666
23 | 5 | 150000 | 2021-05-27 00:00:00 |  | 26 | 100000 | 1234 |  |  | 23 | 25000 | 2021-05-26 00:00:00 | 25000 | 666
24 | 6 | 50000 | 2022-08-01 00:00:00 |  | 26 | 100000 | 4567 |  |  | 23 | 150000 | 2021-05-27 00:00:00 | 150000 | 666
24 | 7 | 100000 | 2022-09-08 00:00:00 |  |  |  |  |  |  | 24 | 50000 | 2022-08-01 00:00:00 | 50000 | 222
24 | 8 | 10000 | 2022-12-05 00:00:00 |  |  |  |  |  |  | 24 | 100000 | 2022-09-08 00:00:00 | 0 | Insufficient Stock
25 | 9 | 40000 | 2023-02-05 00:00:00 |  |  |  |  |  |  | 24 | 10000 | 2022-12-05 00:00:00 | 0 | Insufficient Stock
25 | 10 | 15000 | 2023-05-08 00:00:00 |  |  |  |  |  |  | 25 | 40000 | 2023-02-05 00:00:00 | 40000 | 999
26 | 11 | 140000 | 2023-08-08 00:00:00 |  |  |  |  |  |  | 25 | 15000 | 2023-05-08 00:00:00 | 0 | Insufficient Stock
 |  |  |  |  |  |  |  |  |  | 26 | 150000 | 2023-08-08 00:00:00 | 100000 | 1234
 |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 4567
Spreadsheet: 725924d1616972261-lookup-cell-between-dates-question-_ken
Sheet: Sheet1

Date of manufacture | Battery to use |  |  | Battery | Battery opened | [NAME] | [NAME] on TODAY
2020-10-10 00:00:00 |  |  |  | A | 2020-09-23 00:00:00
 |  |  |  | B | 2020-12-24 00:00:00
 |  |  |  | C | 2021-03-26 00:00:00
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: DzontraVolta

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
DzontraVolta
offlineDzontraVolta
Remove friend Send message Donate
Experience level 26
9,112 / 10,000
Location: UkraineUkraine, Subcarpathia Citizenship: CroatiaCroatia
eRepublik birthday
May 24, 2011
National rank: 1587
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(887)
best zomg
KivO.B
[NAME]
VikiBiH
mahfghdhgh
Lord BlackASH
Tomo mih
ClioPilot
Ante The Animal
view all
Land of DzontraVolta: 23 buildings
Visit
About me
Wiki page
[NAME] bre ti šilibajzeru﻿ [NAME] bre ja? [NAME] bre DžontraVolta!!!!!
Achievements
hard worker
4
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
5
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
1,380.00
Super soldier:1,380 / 1,500
Rank
Lt Colonel ***Lt Colonel ***
Rank points:
236,265 / 285,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 114639d1310393161-conditional-formatting-help-sales-by-fiscal-week-dummy
Sheet: sales

 | wk1 | wk2 | wk3
store 1 | 22 | 25 | 6 | 45 | 33 | 12
store 2 | 98 | 0 | 33 | 36 | 11 | 28
store 3 | 0 | 0 | 31 | 0 | 0 | 0
Spreadsheet: 771091d1646409579-limitations-in-xpath-1-0-in-filterxml-various-nodes
Sheet: Sheet2

D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69
D4866064DE10 |  |  | 52 | 56 | 54 | 54 | 48 | 54 | 52 | 68 | 69