tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116949d1312329191-logical-test-for-integer-or-non-integer-rpdcalc
Sheet: Sheet1

 | Sample No | BH75-3 | BH75-4* | RPD | Detect Limit |  | Sample No | BH75-3 | BH75-4* | RPD | Detect Limit
 | Arsenic | 23 | 6 | 1.172413793103448 | 5 |  | Arsenic | 23 | 6 | 1.172413793103448 | 5
 | Cadmium | 0.2 | 0.2 | 0 | 0.2 |  | Cadmium | 0.2 | 0.2 | 0 | 0.2
 | Chromium | 37 | 30 | 0.208955223880597 | 5 |  | Chromium | 37 | 30 | 0.208955223880597 | 5
 | Copper | 53 | 40 | 0.2795698924731183 | 5 |  | Copper | 53 | 40 | 0.2795698924731183 | 5
 | Lead | 980 | 51 | 1.802133850630456 | 5 |  | Lead | 980 | 51 | 1.802133850630456 | 5
 | Mercury | <0.05 | <0.05 | #N/A | 0.05 |  | Mercury | <0.05 | <0.05 | BBL | 0.05
 | Nickel | 23 | 13 | 0.5555555555555556 | 5 |  | Nickel | 23 | 13 | 0.5555555555555556 | 5
 | Selenium | <3 | 3.5 | #N/A | 3 |  | Selenium | <3 | 3.5 | 0.1538461538461539 | 3
 | Tin | 660 | 56 | 1.687150837988827 | 10 |  | Tin | 660 | 56 | 1.687150837988827 | 10
 | Zinc | 130 | 87 | 0.3963133640552995 | 5 |  | Zinc | 130 | 87 | 0.3963133640552995 | 5
 | TPH C6-C9 | <20 | <20 | #N/A | 20 |  | TPH C6-C9 | <20 | <20 | BBL | 20
 | [NAME] | <20 | <20 | #N/A | 20 |  | [NAME] | <20 | <20 | BBl | 20
 | TPH C15-C28 | <50 | <50 | #N/A | 50 |  | TPH C15-C28 | <50 | <50 | BBL | 50
 | TPH C29-C36 | <50 | <50 | #N/A | 50 |  | TPH C29-C36 | <50 | <50 | BBL | 50
 | Benzo(a)Pyrene (B(a)P) | <0.1 | <0.1 | #N/A | 0.1 |  | Benzo(a)Pyrene (B(a)P) | <0.1 | <0.1 | BBL | 0.1
 | Total PAH | <0.1 | <0.1 | #N/A | 0.1 |  | Total PAH | <0.1 | <0.1 | BBL | 0.1
Spreadsheet: 517770d1494556609-how-to-trigger-alert-for-7-consecutive-dates-with-data-on-cell-sample2
Sheet: Sample

Name | Designation | Emp No | 2017-05-20 00:00:00 | 2017-05-21 00:00:00 | 2017-05-22 00:00:00 | 2017-05-23 00:00:00 | 2017-05-24 00:00:00 | 2017-05-25 00:00:00 | 2017-05-26 00:00:00 | 2017-05-27 00:00:00 | 2017-05-28 00:00:00 | 2017-05-29 00:00:00 | 2017-05-30 00:00:00 | 2017-05-31 00:00:00 | TOTAL | Accumulate Work Days Alert
 |  |  | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED
[NAME] | General Worker | 111 |  |  | 7 | 7 | 7 | 7 | 7 |  |  | 7 |  |  |  |  |  | Holidays
OTx1.5(Hr) |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 2017-05-01 00:00:00
OTx2.0(Hr) |  |  |  |  |  |  |  |  |  |  | OFF |  |  |  |  |  |  | 2017-05-10 00:00:00
YYY | General Worker | 222 |  |  | 7 | 7 | 7 | 7 | 7 |  |  |  |  |  |  |  |  | Holidays
OTx1.5(Hr) |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 2017-05-01 00:00:00
OTx2.0(Hr) |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 2017-05-10 00:00:00
Spreadsheet: 59681d1260270487-displaying-multiple-results-with-vlookup-example
Sheet: Sheet1

 |  |  |  |  | This is where Im at at the moment, this only gives me one result for the registration abc 123, I want it to give me all the occurences where this registration appears
#N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  | This is how I want the data to come out, if needs be I can place a button in to have it search for the registration that I am looking for
 |  | abc 123
abc 123 | 1995-10-01 00:00:00 | G Smith | Ford | 199
abc 123 | 1997-05-20 00:00:00 | G Smith | Ford | 145
abc 123 | 2001-12-01 00:00:00 | G Smith | Ford | 212
abc 123 | 2007-02-27 00:00:00 | G Smith | Ford | 45
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: scale

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 23.75 | 3.29 |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 | 23.75 | 3.3 |  |  |  |  |  |  |  |  | NEW DEALS
 | 15.5 | 3.31
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  | 20000
 |  | 3.33 | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 849841d1700222925-novice-attempting-a-work-schedule-shift-schedule
Sheet: Shifts

Shift Patterns
E | E | 08:00:00 | 17:00:00
E1 | E1 | 08:00:00 | 15:00:00
E2 | E2 | 08:00:00 | 22:00:00
E3 | E3 | 09:00:00 | 23:00:00
A1 | A1 | 13:00:00 | 22:00:00
A1 | A1 | 14:00:00 | 23:00:00
A2 | A2 | 16:00:00 | 23:00:00
A3 | A3 | 15:00:00 | 22:00:00
N
O
HOL
N1
N2
OFF
TRAIN
EL
P
B
M
Spreadsheet: 883845d1732584958-conditional-formatting-for-due-dates-eabaker64-sample2-tms
Sheet: Using First Formula

List created | List sent | First | Second | Holidays |  |  |  | First Formula
2024-09-20 00:00:00 | 2024-09-24 00:00:00 |  |  | 2024-07-04 00:00:00 |  | Green |  | =NETWORKDAYS.INTL(A2,IF(B2="",TODAY(),B2),,$E$2:$E$7)<=3
2024-10-11 00:00:00 |  |  |  | 2024-09-02 00:00:00 |  | Red |  | =NETWORKDAYS.INTL(A2,IF(B2="",TODAY(),B2),,$E$2:$E$7)>3
2024-11-14 00:00:00 | 2024-11-20 00:00:00 |  |  | 2024-10-14 00:00:00
2024-11-20 00:00:00 |  |  |  | 2024-11-11 00:00:00
2024-11-21 00:00:00 |  |  |  | 2024-11-28 00:00:00
2024-12-22 00:00:00 |  |  |  | 2024-12-25 00:00:00
Spreadsheet: 327662d1403637562-sum-column-total-until-next-occurrence-dl-oeldere4-327627d1403629882-sum-column-total-until-next-occurrence-bwmuhich-oeldere-327606d
Sheet: Sheet2

70 | BO
71 | BP
72 | BQ
73 | BR
74 | BS
75 | BT
76 | BU
77 | BV
78 | BW
79 | BX
80 | BY
81 | BZ
82 | CA
83 | CB
84 | CC
85 | CD
86 | CE
87 | CF
88 | CG
89 | CH
90 | CI
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5311

5311 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 745269d1629825017-maxifs-ignoring-text-values-maxifs-for-selected-items-only-excel-forum
Sheet: Sheet2

 | =IF(F4=1,MAXIFS($B$10:$B$180,$C$10:$C$180,1),"") |  |  |  | Available / Price
 |  |  |  | Maximum calorie content of selected items:
 | Select -> |  |  |  | 1 | 1
 | Calories | Select | Category | Type | Member | Guest
 | 300 |  | Ice Cream | [NAME] | 2.79 | 3.89
 | 325 |  | Ice Cream | Chocolate | 2.79 | 3.89
 | 250 | 1 | Ice Cream | Vanilla | 2.79 | 3.89
 | 225 |  | Ice Cream | Pineapple | n/a | n/a
 | 350 |  | Ice Cream | Chocolate Chip | 4 | 4.5
 | 375 |  | Premium Ice Cream | Mint Chocolate Chip | 4.5 | n/a
 | 400 |  | Premium Ice Cream | Caramel Pecan Swirl | 5 | n/a
 | Calories | Select | Category | Toppings | Standard | Sugar Free
 | 50 | 1 | Nuts | Peanuts | 1 | 1
 | 50 |  | Nuts | Pecans | 1.5 | 1.5
 | 410 | 1 | Syrup | Dark Chocolate Pecan Fudge | 1.75 | n/a
 | 150 | 1 | Syrup | [NAME] | 1.75 | n/a
 | 25 |  | Sprinkles | Coconut | 1 | 1.3
Spreadsheet: 124331d1318339307-excel-2007-advanced-auto-sum-copy-of-excel12-1
Sheet: Load Information

 |  | DATE:
 |  | FLIGHT:
 |  | REG:
ULD# | ULD WT | PAYLOAD | TOTAL WT | ATTENTION
 | 120 | 1
 | 220 | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
TOTAL WEIGHT: |  | Kg.
Spreadsheet: 752592d1634841379-circular-reference-issue-copy-of-excel-employee-vacation-sheet-2021-prototype
Sheet: Nov

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative A; Approved
Compressed Day Off
Assignment / Left
Half Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
November | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
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 |  | Replaced by:
November Total
Spreadsheet: 832483d1686351537-a-column-that-sums-other-columns-data-but-it-adds-only-from-the-3th-to-the-5th-value-example-1
Sheet: Sheet1

 |  | Year | Sum | Product1 | Product2 | Product3 | Product4 | Product5
 |  | 1 | 0 | 10
 |  | 2 | 0 | 10 | 10
 |  | 3 |  | 5 | 10 |  |  |  |  | 3rd
 |  | 4 |  | 5 | 5 |  |  |  |  | 4th
 |  | 5 |  | 2 | 5 | 10 |  |  |  | 5th
 |  | 6 |  | 2 | 2 | 10
 |  | 7 |  | 1 | 2 | 5 | 10
 |  | 8 |  |  | 1 | 5 | 10 | 10
 |  | 9 |  |  |  | 2 | 5 | 10
 |  | 10 |  |  |  | 2 | 5 | 5
 |  | 11 |  |  |  | 1 | 2 | 5
 |  | 12 |  |  |  |  | 2 | 2
 |  | 13 | 0 |  |  |  | 1 | 2
 |  | 14 | 0 |  |  |  |  | 1
Spreadsheet: 86305d1286313899-value-errors-forum_ex
Sheet: Sheet1

No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | Average Sales
110 | 13135 | 2 | 75 | 16 | 2130 | 0 | 0 | 6 | 1209 | 1 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
29 | 5157 | 2 | 150 | 9 | 981 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Median
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min
29 | 4348 |  |  | 10 | 1580 | 3 | 490 | 1 | 15
58 | 8438 | 5 | 395 | 2 | 280 |  |  | 12 | 300
52 | 7622 | 1 | 40 | 9 | 1484 |  |  | 4 | 80
No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | Average Sales
No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | No | Value | Average Sales
Spreadsheet: 159442d1338650706-limiting-and-if-need-be-resetting-values-in-a-range-of-cells-based-on-the-value-in-another-example
Sheet: Sheet1

Switch | Name | Value
Yes | Label1 | 1
Yes | Label2 | 2
Yes | Label3 | 3
No | SubTotal1 | 6 | <----------- | Value is "No" so rows 2-4 can be either "Yes" or "No"
Yes | Label4 | 3
No | Label5 | 14
Yes | Label6 | 40
No | Label7 | 44
No | SubTotal2 | 101 | <----------- | Value is "No" so rows 7-10 can be either "Yes" or "No"
No | Label8 | 21
No | Label9 | 95
No | Label10 | 4
No | Label11 | 3
No | Label12 | 65
Yes | SubTotal3 | 188 | <----------- | Value is "Yes" so Rows 13-17 need to reset to "No"
No | Total | 295
Spreadsheet: 862135d1709901717-no-results-when-try-to-find-the-talktime-per-hour-count-per-hour-eba
Sheet: Calculation

 |  |  |  | 08:00:00
 | 2024-03-01 00:00:00 | AAAAA | Count
 | 2024-03-01 00:00:00 | AAAAA | Talktime
 | 2024-03-01 00:00:00 | BBBBB | Count
 | 2024-03-01 00:00:00 | BBBBB | Talktime
 | 2024-03-01 00:00:00 | CCCCC | Count
 | 2024-03-01 00:00:00 | CCCCC | Talktime
 | 2024-03-01 00:00:00 | DDDDD | Count
 | 2024-03-01 00:00:00 | DDDDD | Talktime
 | 2024-03-01 00:00:00 | EEEEE | Count
 | 2024-03-01 00:00:00 | EEEEE | Talktime
 | 2024-03-01 00:00:00 | FFFFF | Count
 | 2024-03-01 00:00:00 | FFFFF | Talktime
 | 2024-03-01 00:00:00 | GGGGG | Count
 | 2024-03-01 00:00:00 | GGGGG | Talktime
 | 2024-03-02 00:00:00 | AAAAA | Count
 | 2024-03-02 00:00:00 | AAAAA | Talktime
 | 2024-03-02 00:00:00 | BBBBB | Count
 | 2024-03-02 00:00:00 | BBBBB | Talktime
 | 2024-03-02 00:00:00 | CCCCC | Count
 | 2024-03-02 00:00:00 | CCCCC | Talktime
 | 2024-03-02 00:00:00 | DDDDD | Count
 | 2024-03-02 00:00:00 | DDDDD | Talktime
 | 2024-03-02 00:00:00 | EEEEE | Count
 | 2024-03-02 00:00:00 | EEEEE | Talktime
 | 2024-03-02 00:00:00 | FFFFF | Count
 | 2024-03-02 00:00:00 | FFFFF | Talktime
 | 2024-03-02 00:00:00 | GGGGG | Talktime
 | 2024-03-02 00:00:00 | GGGGG | Talktime
 | 2024-03-03 00:00:00 | AAAAA | Count
 | 2024-03-03 00:00:00 | AAAAA | Talktime
 | 2024-03-03 00:00:00 | BBBBB | Count
 | 2024-03-03 00:00:00 | BBBBB | Talktime
 | 2024-03-03 00:00:00 | CCCCC | Count
 | 2024-03-03 00:00:00 | CCCCC | Talktime
 | 2024-03-03 00:00:00 | DDDDD | Count
 | 2024-03-03 00:00:00 | DDDDD | Talktime
 | 2024-03-03 00:00:00 | EEEEE | Count
 | 2024-03-03 00:00:00 | EEEEE | Talktime
 | 2024-03-03 00:00:00 | FFFFF | Count
 | 2024-03-03 00:00:00 | FFFFF | Talktime
 | 2024-03-03 00:00:00 | GGGGG | Talktime
 | 2024-03-03 00:00:00 | GGGGG | Talktime
Spreadsheet: 66151d1266866119-array-formula-across-multiple-columns-testproduce3
Sheet: Availability

 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
 | Good |  | Bananas | Bananas | Bananas | Bananas
 | Good | Apples |  |  | Apples | Apples |  | Apples
 | Good |  | Pears | Pears | Pears
 | Good |  | Kiwi Fruit | Kiwi Fruit | Kiwi Fruit
 | Good |  | Peaches | Peaches | Peaches
 | Good | Apricots | Apricots | Apricots | Apricots
 | Good | Lettuce | Lettuce | Lettuce | Lettuce | Lettuce
 | Good | Tomato |  | Tomato | Tomato | Tomato
 | Good | Celery |  | Celery | Celery | Celery
 | Good | Potatoe |  | Potatoe | Potatoe
 | Good |  | Cabbage | Cabbage | Cabbage
 | Good | Oranges | Oranges | Oranges | Oranges
 | Good |  | Lemons |  | Lemons |  |  | Lemons
 | Limited | Bananas |  |  |  |  | Bananas | Bananas
 | Limited |  |  |  |  |  | Apples
 | Limited |  |  |  |  | Pears | Pears
 | Limited |  |  |  |  |  | Kiwi Fruit
 | Limited | Peaches |  |  |  |  | Peaches
 | Limited |  |  |  |  | Apricots | Apricots
 | Limited |  |  |  |  |  | Lettuce
 | Limited |  | Tomato |  |  |  | Tomato | Tomato
 | Limited |  |  |  |  |  | Celery
 | Limited |  |  |  |  | Potatoe |  | Potatoe
 | Limited | Cabbage |  |  |  | Cabbage |  | Cabbage
 | Limited |  |  |  |  | Oranges
 | Limited |  |  |  |  | Lemons | Lemons
 | None
 | None |  | Apples | Apples
 | None | Pears |  |  |  |  |  | Pears
 | None | Kiwi Fruit |  |  |  | Kiwi Fruit |  | Kiwi Fruit
 | None |  |  |  |  | Peaches |  | Peaches
 | None |  |  |  |  |  |  | Apricots
 | None |  |  |  |  |  |  | Lettuce
 | None
 | None |  | Celery |  |  |  |  | Celery
 | None |  | Potatoe |  |  |  | Potatoe
 | None |  |  |  |  |  | Cabbage
 | None |  |  |  |  |  | Oranges | Oranges
 | None | Lemons |  | Lemons
Spreadsheet: larry_campbell__21100__Larry Campbell
Sheet: L. Campbell

# | Category | Finding | Action Item | Responsible Person | Target Date | [NAME] | Completion Date | Comments
 | PSM
21 | AIR GMP | Need a system for maintaining compliance with permit requirements. | Incorporate permit conditions requiring an action into the Maintenance Control System (MCS). | [NAME] | 2001-03-31 00:00:00 | [NAME]
29 | HAZARDOUS WASTE Regulation Condition | An assessment of cooling tower area found chromium contamination, but no plan for remediation has been developed. | Determine vertical and lateral extent of chromium contamination. | [NAME] | 2001-06-30 00:00:00 | [NAME]
30 | HAZARDOUS WASTE Regulation Condition | An assessment of the wash rack area found elevated levels of lead, barium, chromium, copper, and mercury. | Determine extent of metals contamination. | [NAME] | 2001-06-30 00:00:00 | [NAME]
31 | HAZARDOUS WASTE Regulation Condition | An assessment of the propane compressor area found elevated levels of lead and chromium. | Determine extent of metals contamination. | [NAME] | 2001-06-30 00:00:00 | [NAME]
32 | HAZARDOUS WASTE Regulation Condition | An assessment of the propane compressor area found elevated levels of benzene. | Determine extent of benzene contamination. | [NAME] | 2001-06-30 00:00:00 | [NAME]
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: SE-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 116144d1311624446-constructing-formula-for-matching-value-separate-spreadsheet-sample-data
Sheet: ledger_report 1 

Virginia Department of Education
Ledger for Page County Public Schools (cash basis for 1st JUL 2011 to 31st JUL 2011)
as of Mon Jul 25 06:58:24 EDT 2011
YEAR | PAYEE | FIPS | PAYEE NAME | PROJECT | PROJECT NAME | FUND | REV SRC | REV SRC NAME | PERIOD | AWARD | GLDATE | AMOUNT | SBO Code
2012 | 069 | 139 | Page County Public Schools | 702750 | 1% Sales Tax | 0100 | 240308 | Sales Tax | JUL11-12 |  | 2011-07-31 00:00:00 | 1 | 1-1-2402010
2012 | 069 | 139 | Page County Public Schools | 700400 | Basic Aid - SOQ Payments | 0100 | 240202 | Basic Aid | JUL11-12 |  | 2011-07-31 00:00:00 | 2 | 1-2-2402020
2012 | 069 | 139 | Page County Public Schools | 707010 | Social Security Benefits - Instructional | 0100 | 240221 | Social Security - Instructional | JUL11-12 |  | 2011-07-31 00:00:00 | 3 | 1-2-2402210
2012 | 069 | 139 | Page County Public Schools | 707410 | Remedial Education - SOQ Payments | 0100 | 240208 | Remedial Education SOQ | JUL11-12 |  | 2011-07-31 00:00:00 | 4 | 1-2-2402080
2012 | 069 | 139 | Page County Public Schools | 702300 | Textbook Payments | 0100 | 240214 | Textbook Payments | JUL11-12 |  | 2011-07-31 00:00:00 | 5 | 1-2-2402140
2012 | 069 | 139 | Page County Public Schools | 701100 | Special Education Payments - SOQ | 0100 | 240212 | Special Education SOQ | JUL11-12 |  | 2011-07-31 00:00:00 | 6 | 1-2-2402120
2012 | 069 | 139 | Page County Public Schools | 625450 | Jails-New Special Ed. Regulation | 0100 | 240295 | Jails-New Special Ed. Regulations | JUL11-12 |  | 2011-07-31 00:00:00 | 789 | 1-2-2402120
2012 | 069 | 139 | Page County Public Schools | 707310 | Group Life-Instructional | 0100 | 240241 | Group Life Instructional | JUL11-12 |  | 2011-07-31 00:00:00 | 541 | 1-2-2402410
2012 | 069 | 139 | Page County Public Schools | 702200 | Teacher Retirement - Instructional | 0100 | 240223 | Teacher Retirement - Instructional | JUL11-12 |  | 2011-07-31 00:00:00 | 2 | 1-2-2402230
2012 | 069 | 139 | Page County Public Schools | 700700 | Education Of The Gifted - SOQ Payments | 0100 | 240207 | Education of the Gifted SOQ | JUL11-12 |  | 2011-07-31 00:00:00 | 1 | 1-2-2402070
2012 | 069 | 139 | Page County Public Schools | 702730 | 1/8% Sales Tax | 0100 | 240312 | 1/8% Sales Tax | JUL11-12 |  | 2011-07-31 00:00:00 | 3.5 | 1-1-2402010
2012 | 069 | 139 | Page County Public Schools | 406230 | NSLP Combined | 1000 | 10.555 | National School Lunch Program | JUL11-12 | 10.555/2011 | 2011-07-31 00:00:00 | 4 | 5-3-3302130
2012 | 069 | 139 | Page County Public Schools | 405910 | School Breakfast Program | 1000 | 10.553 | School Breakfast Program | JUL11-12 | 10.553/2011 | 2011-07-31 00:00:00 | 1 | 5-3-3302131
2012 | 069 | 139 | Page County Public Schools | 701000 | [NAME] | 0100 | 240217 | [NAME] | JUL11-12 |  | 2011-07-31 00:00:00 | 6 | 1-2-2402170
 |  |  |  |  |  |  |  |  |  |  |  | 1368.5
Spreadsheet: c4158749-f159-4264-a44d-e1319a307e47
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44038189 | 2014-11-15 21:58:22 | AXIS | 1 | 7 | 2 | 1589254 | Dieudonné de Laubier | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44038502 | 2014-11-15 22:15:16 | ALLIES | 0 | 4 | 7 | 1589254 | Dieudonné de Laubier | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44055919 | 2014-11-16 23:00:49 | AXIS | 1 | 5 | 4 | 940478 | Junior72 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44056247 | 2014-11-16 23:15:45 | ALLIES | 1 | 5 | 4 | 940478 | Junior72 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44096503 | 2014-11-19 21:30:25 | AXIS | 0 | 5 | 7 | 13513 | Dreexxer | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44096892 | 2014-11-19 21:51:49 | ALLIES | 0 | 3 | 7 | 13513 | Dreexxer | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44110897 | 2014-11-20 23:06:22 | AXIS | 0 | 5 | 6 | 20796 | Titanos | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44111118 | 2014-11-20 23:32:35 | ALLIES | 0 | 4 | 6 | 20796 | Titanos | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44137561 | 2014-11-22 21:58:41 | AXIS | 0 | 4 | 6 | 632845 | [NAME] du Sud | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44138000 | 2014-11-22 22:23:19 | ALLIES | 1 | 6 | 1 | 632845 | [NAME] du Sud | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44153717 | 2014-11-23 22:12:58 | ALLIES | 1 | 5 | 1 | 1601877 | [NAME] | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
44153870 | 2014-11-23 22:27:18 | AXIS | 0 | 3 | 5 | 1601877 | [NAME] | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
44194416 | 2014-11-26 22:18:14 | ALLIES | 0 | 2 | 10 | 240776 | DoctorSchizzo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44195583 | 2014-11-26 23:39:34 | AXIS | 1 | 10 | 6 | 240776 | DoctorSchizzo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 42034d1240568848-extracting-multiple-information-sample
Sheet: Sheet1

Surname | Date Arrival | Date Departure | Nº of Nights
ClientA | 2005-12-25 00:00:00 | 2006-01-13 00:00:00 | 19
ClientB | 2005-11-21 00:00:00 | 2006-02-13 00:00:00 | 84
ClientC | 2005-11-07 00:00:00 | 2006-01-01 00:00:00 | 55
ClientD | 2007-07-08 00:00:00 | 2007-07-22 00:00:00 | 14
ClientE | 2006-01-09 00:00:00 | 2006-04-03 00:00:00 | 84
ClientA | 2006-01-12 00:00:00 | 2006-03-13 00:00:00 | 60
ClientB | 2005-10-22 00:00:00 | 2006-02-18 00:00:00 | 119
ClientC | 2005-12-19 00:00:00 | 2006-04-17 00:00:00 | 119
ClientD | 2005-10-01 00:00:00 | 2006-03-18 00:00:00 | 168
ClientE | 2005-11-26 00:00:00 | 2005-12-31 00:00:00 | 35
Surname | Date Arrival | Date Departure | Nº of Nights
ClientA | 2005-12-25 00:00:00 | 2006-01-13 00:00:00 | 19
ClientE | 2006-01-09 00:00:00 | 2006-04-03 00:00:00 | 84
ClientC | 2005-11-07 00:00:00 | 2006-01-01 00:00:00 | 55
ClientB | 2005-11-21 00:00:00 | 2006-02-13 00:00:00 | 84
ClientD | 2007-07-08 00:00:00 | 2007-07-22 00:00:00 | 14