tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 870528d1717029317-vlookup-conditioned-to-a-date-test
Sheet: Expected result

 | Expected result | Expected result | Expected result
 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00
Simar, [NAME] | 153416.76 | 74412.62999999999 | 220166.81
[NAME] | 0 | 13603.48 | 39191.64
M.E.R. Construções, unipessoal Lda | 44930.24 | 59999.16 | 36869.42
Total | 198347 | 148015.27 | 296227.87
 | 2022-02-01 00:00:00 | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
Simar, [NAME] | 184691.47 | 110894.76 | 290893
[NAME] | 3004.25 | 10344 | 50955.16
M.E.R. Construções, unipessoal Lda | 53221.64 | 76907.92000000001 | 36873.67
Total | 240917.36 | 198146.68 | 378721.83
 | 2022-03-01 00:00:00 | 2023-03-01 00:00:00 | 2024-03-01 00:00:00
Simar, [NAME] | 351739.02 | 130549.82 | 224322.46
Pfeiffer Baugesellschaft mbH |  | 137720.77
[NAME] | 52276 | 7704 | 49152.68
M.E.R. Construções, unipessoal Lda | 45945.85 | 57922.84 | 49131.07
Total | 449960.87 | 333897.4299999999 | 322606.21
 | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00
Simar, [NAME] | 512138.49 | 116486.17 | 204148.46
Pfeiffer Baugesellschaft mbH |  | 70079.17
[NAME] | 10616 | 5832 | 58185.3
M.E.R. Construções, unipessoal Lda | 56579.81 | 62697.56 | 39587.67
Total | 579334.3 | 255094.9 | 301921.43
 | 2022-05-01 00:00:00 | 2023-05-01 00:00:00 | 2024-05-01 00:00:00
Simar, [NAME] | 334762.63 | 171572.35 | 275000
Pfeiffer Baugesellschaft mbH |  | 0
[NAME] | 16316 | 4596 | 61094.1
M.E.R. Construções, unipessoal Lda | 45591.45 | 43301.16 | 44000
Total | 396670.08 | 219469.51 | 380094.1
Spreadsheet: 97863d1296972678-recording-vertical-outcome-data-into-horizontal-different-time-period-sample
Sheet: Sheet1

[NAME] | Date | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass
10 | 2009-03-30 00:00:00 | 3. Good | 3 |  | No | N | N | Y | 2 days | 13 |  | 17 | Unable to lift weight |  | 10 | y
10 | 2008-12-05 00:00:00 | 3. Good |  | y | 1 time | N | N | Y | 5 or more days | 10 |  | 9 | 5 lb. (Female) | Left | 8 | y
10 | 2009-11-17 00:00:00 | 4. Fair | 2 |  | 1 time | Y | N | N | 1 day | 12 |  | 10 | 5 lb. (Female) | Right | 10 | y
10 | 2010-03-18 00:00:00 | 3. Good | 4 |  | No | N | N | Y | 1 day | 13 |  | 10 | 5 lb. (Female) | Right | 8 | y
10 | 2010-10-04 00:00:00 | 4. Fair | 4 |  | No | N | N | Y |  | 12 |  | 10 |  |  | 13 | y
19 | 2009-03-30 00:00:00 | 3. Good | 3 |  | No | N | N | N | 5 or more days | 12 |  | 16 | 5 lb. (Female) | Right |  | y
19 | 2008-12-19 00:00:00 | 3. Good |  | y | No |  |  | Y | 5 or more days | 10 |  | 10 | 5 lb. (Female) | Left | 14 | y
19 | 2009-12-01 00:00:00 | 3. Good | 3 |  | No | N | N | N | None | 11 |  | 17 | 5 lb. (Female) | Right | 13 | n
19 | 2010-09-08 00:00:00 | 3. Good | 4 |  | 1 time | N | N | N |  | 11 |  | 16 | 5 lb. (Female) | Right | 17 | y
22 | 2008-12-01 00:00:00 | 3. Good |  | y | No |  |  | Y | 5 or more days | 9 |  | 20 | 5 lb. (Female) | Right | 12 | y
22 | 2009-03-31 00:00:00 | 3. Good | 5 |  | No | N | N | Y | 5 or more days | 0 |  | 29 | 5 lb. (Female) | Right | 11 | y
22 | 2009-12-31 00:00:00 | 2. [NAME] | 5 |  | No | N | N | Y | 5 or more days | 12 |  | 24 | 5 lb. (Female) | Right | 12 | y
22 | 2010-06-01 00:00:00 | 3. Good | 5 |  | No |  |  | Y | 3 days | 5 |  | 4 | 5 lb. (Female) | Right | 23 | y
22 | 2010-12-10 00:00:00 | 3. Good | 5 |  | No | N |  | Y | 3 days | 8 |  | 11 | 5 lb. (Female) | Left | 17 | n
[NAME] | Date1 | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass | Date2 | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass | Date3 | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass | [NAME] | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass | Date5 | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass | Date6 | Health | ABILITIES | NEW | NUMBER_Exercise | Ins | CUTBACK_ACTVTY | LEVEL | Run | [NAME] | [NAME] | CURL | C_WT | WHICH_ARM | UG | Ass
Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: Logos

SALES PERSON | SALES TEAM | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
[NAME] | ASM | 14 | 13 | 9 | 10 | 11 | 6 | 14 | 11 | 6 | 16 | 4
[NAME] | Team Zac | 8 | 8 | 11 | 7 | 10 | 11 | 9 | 15 | 10 | 16 | 7
[NAME] | Team Zac | 8 | 11 | 13 | 10 | 10 | 7 | 12 | 7 | 10 | 8 | 3
[NAME] | ASM | 10 | 5 | 10 | 6 | 10 | 9 | 12 | 11 | 10 | 10 | 5
[NAME] | Team Andy | 8 | 10 | 14 | 10 | 11 | 12 | 6 | 8 | 8 | 3 | 5
[NAME] | Team Seth | 5 | 8 | 17 | 7 | 8 | 12 | 7 | 5 | 4 | 5 | 0
[NAME] | Team Seth | 7 | 6 | 10 | 5 | 8 | 10 | 5 | 6 | 6 | 10 | 2
[NAME] | Team Seth | 7 | 9 | 4 | 6 | 4 | 6 | 3 | 10 | 7 | 9 | 5
[NAME] | ASM | 6 | 3 | 10 | 10 | 7 | 7 | 2 | 9 | 7 | 8 | 0
[NAME] | Team Zac | 10 | 2 | 10 | 4 | 4 | 7 | 4 | 9 | 2 | 7 | 2
[NAME] | Team [NAME] | 10 | 8 | 7 | 4 | 8 | 4 | 5 | 5 | 2 | 6 | 1
Mitch Tharp | Team Andy | 4 | 7 | 7 | 5 | 3 | 6 | 2 | 7 | 10 | 6 | 2
[NAME] | Team Andy | 4 | 4 | 7 | 3 | 9 | 6 | 5 | 5 | 6 | 2 | 3
[NAME] | Team Andy | 4 | 5 | 4 | 6 | 4 | 3 | 5 | 7 | 7 | 6 | 2
[NAME] | Team Zac | 7 | 5 | 7 | 3 | 5 | 3 | 5 | 2 | 5 | 0 | 0
[NAME] | Team Seth |  |  |  |  |  |  |  | 10 | 12 | 15 | 2
[NAME] | Team Zac |  |  |  |  |  |  |  |  | 15 | 14 | 4
[NAME] | Team Andy |  |  | 3 | 5 | 3 | 4 | 3 | 3 | 5
[NAME] | Team Seth |  |  |  |  |  |  |  |  | 10 | 10 | 3
[NAME] | Team Zac |  |  | 3 | 7 | 4 | 5
[NAME] | N/A |  |  |  |  |  |  |  |  | 7 | 11 | 0
[NAME] | Team Seth |  |  | 3 | 2 | 3 | 4 | 2 | 2
[NAME] | N/A |  |  |  |  |  |  |  |  |  | 1 | 3
 | 2022 New Logo Total
 | 2021 New Logo Total | 147 | 119 | 120 | 113 | 150 | 110 | 118 | 122 | 133 | 115 | 128 | 92
 | % Goal Attainment
 | New Logo Variance
 | Working Days Left in Month | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 21
 | Logos Needed Per Day
 | New Logo Running Variance
ASM TEAM NEW LOGOS
SALES TEAM |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
Team Andy
Team [NAME] [NAME]
Team Seth
Team Seth w/ [NAME]
Team Zac
Team Zac w/ [NAME]
Team [NAME]
ASM
TOTAL
Spreadsheet: 227630d1365772262-automatic-transfer-of-data-test-book
Sheet: Master Sheet

Job Number | Date | Time | Person  Reported | Site | Location | Problem | Floor | Assigned to  Maintenance | Comments | Reported/Not Reported | Completed | Total Hours
1 | 2013-04-11 00:00:00 |  | [NAME] | Buckingham Palace | [NAME] | There is a leak in the toilet |  | [NAME] |  | N | Y | 4
2 | 2013-04-12 00:00:00 |  | [NAME] | [NAME] | Office | Radiator Leaking |  | [NAME] |  | N | Y | 1
3 | 2013-04-13 00:00:00 |  | [NAME] | Wembley | Changing Room | Light not working |  | [NAME] | Had to change Light fitting | N | Y | 2.5
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 6

 | October 18 | October 25 | November 1 | November 8 | November 15
Total Interest Rate* | 3574320 | 2283320 | 2968995 | 3638807 | 3014536
SDs and MSPs** | 1616199 | 970202 | 1270391 | 1437794 | 1387659
Other | 1958121 | 1313118 | 1698604 | 2201013 | 1626877
Total Cross-Currency | 68306 | 72392 | 101146 | 161620 | 100879
SDs and MSPs | 57075 | 44320 | 78995 | 112608 | 71592
Other | 11231 | 28072 | 22150 | 49012 | 29287
Total Credit | 1035203 | 657203 | 731447 | 764488 | 608408
SDs and MSPs | 644537 | 409613 | 452462 | 485298 | 382740
Other | 390666 | 247589 | 278985 | 279190 | 225668
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 4677828 | 3012915 | 3801587 | 4564915 | 3723823
Weekly total, swap dollar volumes by asset class and participant type (value of all trades in millions of USD), all products and tenors, cleared and uncleared. For cleared swaps, the notional value for each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, the notional value of the swap is attributed to both swap counterparties. The notional values of all price-forming trade events, including new trades, terminations, amendments, and novations, are included in dollar volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Dollar Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: jason_wolfe__13513__Harbor Aug01 Send Gas
Sheet: Sheet1

Harbor Gas
Month: | August
 |  |  | Gas Daily | Gas Daily | Amount Due
Date | Order | Usage | $/MMBtu | $/MMBtu | $
2001-08-01 00:00:00 |  | 3
2001-08-02 00:00:00 | 5000 | 12272 | 3.735
2001-08-03 00:00:00 |  | 12708
2001-08-04 00:00:00 |  | 2
2001-08-05 00:00:00 |  | 6
2001-08-06 00:00:00 |  | 0
2001-08-07 00:00:00 | 7500 | 7967.3 | 3.64
2001-08-08 00:00:00 | 7500 | 8480.7 | 3.65
2001-08-09 00:00:00 | 16000 | 9761.3 | 3.47
2001-08-10 00:00:00 |  | 1.8
2001-08-11 00:00:00
2001-08-12 00:00:00
2001-08-13 00:00:00
2001-08-14 00:00:00
2001-08-15 00:00:00 | 7500 |  | 3.075
2001-08-16 00:00:00
2001-08-17 00:00:00
2001-08-18 00:00:00
2001-08-19 00:00:00
2001-08-20 00:00:00
2001-08-21 00:00:00
2001-08-22 00:00:00
2001-08-23 00:00:00
2001-08-24 00:00:00
2001-08-25 00:00:00
2001-08-26 00:00:00
2001-08-27 00:00:00
2001-08-28 00:00:00
2001-08-29 00:00:00
2001-08-30 00:00:00
2001-08-31 00:00:00
Balance
Spreadsheet: 103097d1300913661-how-to-display-a-yes-or-a-no-book1
Sheet: Sheet1

Title | First Name | Last Name | Address | City | State | Zip | [NAME] | Live in MN
Mr. | Ricardo | Hernandez | 8765 15th Street | Uturn | MN | 22222
Mrs. | [NAME] | Han | 9898 Elephant Stomping Ground | Heard | GA | 31123
Miss. | Stencil | Smith | 2424 Platypus Boulevard | Cayenne | VA | 11243
Dr. | [NAME] | Jones | 1111 Nowhere Highlands | Uturn | MN | 30655
Spreadsheet: 853052d1703005201-filter-using-match-and-search-filter-with-multiple-conditions-help-example-
Sheet: Sheet1

DATABASE BACKEND EXAMPLE
FUNDER NAME | GRANT SIZE | CATEGORY
A | 5000 | Health, Art
B | 2000 | Environment, Art
C | 5000 | Health, Cancer
D | 5000 | Building Project
FRONT-END USER INPUT
 | INPUT MINIMUM GRANT SIZE BELOW | LIST YOUR CATEGORIES
 | 5000 | Art
 |  | Building
D
Spreadsheet: 681086d1591349533-count-based-on-join-date-performance-analysis
Sheet: Sheet1

New Applicant ID | New Applicant Name | Referral ID | Referral Name | New Applicant Join Date ID | New Applicant Order Count | New Applicant Order Date | New Applicant Recruitment in 84 days from Joined Date | New Applicant Total Order Count in 84 days from Joined Date
5002935 | [NAME] | 13945193 | [NAME] | 2020-04-10 00:00:00 | 1 | 2020-04-26 00:00:00 |  | I want to know total how many times that this new applicant had placed an order (count cell content) since the joined date till <=84 days.
13945193 | [NAME] | 10819867 | [NAME] | 2020-02-12 00:00:00 | 1 | 2020-05-10 00:00:00
5011059 | [NAME] | 7878917 | Maureen Shing Cheh [NAME] | 2020-02-06 00:00:00 | 0 | 2020-04-10 00:00:00
10819867 | [NAME] | 5016999 | [NAME] ng | 2020-02-12 00:00:00 | 1 | 2020-03-01 00:00:00
5014891 | Sze Sze Geow | 10819867 | [NAME] | 2020-03-02 00:00:00 | 0 | 2020-03-15 00:00:00
7878917 | Maureen Shing Cheh [NAME] | 12383152 | Sing Fang Ling | 2020-01-10 00:00:00 | 1 | 2020-04-19 00:00:00
5016999 | [NAME] ng | 13945193 | [NAME] | 2020-04-17 00:00:00 | 0 | 2020-04-21 00:00:00
5029795 | Chee [NAME] | 12383152 | Sing Fang Ling | 2020-05-29 00:00:00 | 1 | 2020-06-01 00:00:00
5031529 | [NAME] | 5002935 | [NAME] | 2020-01-17 00:00:00 | 0 | 2020-03-29 00:00:00
5032695 | [NAME] | 7878917 | Maureen Shing Cheh [NAME] | 2020-05-29 00:00:00 | 1 | 2020-04-26 00:00:00
5035734 | [NAME] | 5014891 | Sze Sze Geow | 2020-02-07 00:00:00 | 1 | 2020-04-17 00:00:00
5037605 | [NAME] | 12383152 | Sing Fang Ling | 2020-04-17 00:00:00 | 1 | 2020-05-22 00:00:00
12383152 | Sing Fang Ling | 5046545 | Soon [NAME] | 2020-02-27 00:00:00 | 1 | 2020-02-28 00:00:00
5037857 | [NAME]  Yet [NAME] | 5038081 | [NAME] | 2020-03-06 00:00:00 | 0 | 2020-03-15 00:00:00
5041241 | [NAME] | 10819867 | [NAME] | 2020-05-15 00:00:00 | 0 | 2020-05-17 00:00:00
5042455 | [NAME] | 5035734 | [NAME] | 2020-04-25 00:00:00 | 1 | 2020-05-23 00:00:00
5046545 | Soon [NAME] | 13945193 | [NAME] | 2020-01-04 00:00:00 | 0 | 2020-03-15 00:00:00
Spreadsheet: 118888d1314080075-pull-out-data-from-an-array-book1
Sheet: Sheet1

Block of data
Approved |  | 2011-08-19 00:00:00 | A
Approved |  | 2011-08-19 00:00:00 | B
Rejected |  | 2011-08-19 00:00:00 | C
Approved |  | 2011-08-19 00:00:00 | D
Approved |  | 2011-08-19 00:00:00 | E
Approved |  | 2011-08-19 00:00:00 | F
Rejected |  | 2011-08-19 00:00:00 | G
Result I want
Approved |  | 2011-08-19 00:00:00 | A
Approved |  | 2011-08-19 00:00:00 | B
Approved |  | 2011-08-19 00:00:00 | D
Approved |  | 2011-08-19 00:00:00 | E
Approved |  | 2011-08-19 00:00:00 | F
Spreadsheet: 738362d1624987880-formula-to-add-2-to-the-cell-but-to-reset-once-the-counter-would-exceed-9-sfic-pinning-calculator
Sheet: Sheet1

Control Key Bitting
Master Key Bitting
Initial Change key bitting
Group 1 Change key bittings |  |  |  |  |  |  |  |  |  | Group 5 Change Key bittings
 | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7
Key Designation |  |  |  |  |  |  |  |  |  | Key Designation
1 |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  | 5
Group 2 Change Key bittings |  |  |  |  |  |  |  |  |  | Group 6 Change Key bittings
 | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7
Key Designation |  |  |  |  |  |  |  |  |  | Key Designation
1 |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  | 5
Group 3 Change Key bittings |  |  |  |  |  |  |  |  |  | Group 7 Change Key bittings
 | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7
Key Designation |  |  |  |  |  |  |  |  |  | Key Designation
1 |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  | 5
Group 4 Change Key bittings
 | Pin Number | 1 | 2 | 3 | 4 | 5 | 6 | 7
Key Designation
1
2
3
4
5
Spreadsheet: 485419d1476877808-i-need-to-find-a-formula-that-calculates-how-much-time-falls-into-a-certain-criteria-sampel-work-cal-_-as-_-different-options-available
Sheet: AS3

 | Hours of work |  |  | Total | Total
 | Day | Start time | end time | hours | pay
 |  | 2016-10-15 20:30:00 | 2016-10-16 07:15:00
 |  | 2016-10-16 22:30:00 | 2016-10-17 07:15:00
 |  | 2016-10-17 22:30:00 | 2016-10-18 07:15:00
 |  | 2016-10-18 22:30:00 | 2016-10-19 06:15:00
 |  | 2016-10-20 07:30:00 | 2016-10-20 18:15:00
Spreadsheet: 2d99c09c-239b-47ca-8a2a-3a3542dc361e
Sheet: Sheet1

RBC Metabolite Abbreviations | RBC Steady State concentrations (mM)
G6P | 0.0664400827021192
F6P | 0.0272334633150771
FDP | 0.0138610362675803
DHAP | 0.147408623163154
GAP | 0.00669858241785389
DPG13 | 0.00022892738135254
DPG23 | 4.65453542859227
PG3 | 0.0839276737418931
PG2 | 0.0122675385744025
PEP | 0.0208741130383975
PYR | 0.06
LAC | 1.39709204859424
NADH | 0.0305991838038541
GL6P | 0.00175427227281622
GO6P | 0.0374752579445004
NADPH | 0.0655988177813823
GSH | 3.31743592984892
RU5P | 0.00493679034382819
R5P | 0.0126689356415438
X5P | 0.0147841958548763
S7P | 0.023987984207419
E4P | 0.00507506957775397
ADO | 5.19232373725237e-05
AMP | 0.148828017425177
ADP | 0.490203292035046
ATP | 2.40161335646115
PRPP | 0.0136605653133729
IMP | 0.019284858506508
INO | 4.27615756088707e-05
HX | 0.00022604103744876
R1P | 0.00117312879463264
ADE | 0.0010347368190222
NAI | 14.1352382264367
KI | 139.88170882204
Spreadsheet: 794610d1662139371-multiple-data-pull-from-source-sonal-file
Sheet: Analysis by Homes

WEEKLY KEY PERFORMANCE INDICATORS
Date (today)
Home (Region) | Acton Care Centre
 |  | June | June | June | June | July | July | July | July | July | Aug | Aug | Aug | Aug
 | Available Beds
 | Occupancy
 | Occupancy %
 | Occupancy Budget
 | [NAME]
 | Admission
 | Discharges
 | Permanent
 | Respite
 | AWF
 | AWF Budget
 | GCH Employee Hours
 | Agency Hours
 | Total Worked Hours
 | WE 28Aug22
 | Admissions |  |  |  |  |  |  |  |  | Discharges
 | Name | Home | Week Fee | Date of Adm | Service | Funding |  |  |  | Name | Home | Week Fee | Date of Adm | Date of Dis | Service | Funding
 | [NAME]
Spreadsheet: 134771d1325626030-need-help-visual-basic-copying-rows-until-empty-cell-need-help-
Sheet: Sheet1

 |  |  |  |  | - - - - - FROM 01.11.2011 TO 30.11.2011 - - - - - |  |  |  | - - - | ---------------------CUMULATIVE-------------------
 | PERSONNEL NAME | BILL | HOME | CONTRACT |  |  | PAYROLL | [NAME] |  |  |  | PAYROLL | [NAME]
PERS  # | OR [NAME] | CODE | COST CTR | BILL RATE | HOURS | PAYROLL | [NAME] | PAYROLL | EXPENSES | HOURS | PAYROLL | [NAME] | PAYROLL | EXPENSES
Time Distribution
12312312 | Name#1 | 80 | 22222222 |  | 0 | 0 | 0 | 10 | 0 | 80 | 1231231 | 3121231231 | 1231231231 | 0
31235132 | Name#2 | 51 | 33333333 |  | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Total Time Report Distribution |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 80 | 1231231 | 1231232131 | 1231231231 | 0
DIRECT POSTING DISTRIBUTION
TRANSPORTATION
Spreadsheet: 789013d1658844692-provide-the-2nd-lastest-price-value-from-a-row-lookup-2nd-last-value-issue-_new
Sheet: Comparison

 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4 |  |  |  |  |  | 70.63000000000001 |  |  |  |  |  | 74.02 |  |  |  |  |  | 60.92
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz |  |  |  |  |  | 21.45 |  |  |  |  |  | 38.44 |  |  |  |  |  | 24.66
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 22.85
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.3 |  | 20.76
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 17.44
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz |  |  |  |  |  | 18.05 |  |  |  |  |  |  |  |  |  |  |  | 17.44
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  |  |  |  |  |  |  |  |  |  |  |  | 18.04 |  | 22.44 |  |  | 22.16
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB
Spreadsheet: 769485d1645554252-increment-with-exclude-array-list-criteria-for-every-nth-duplicate-increment-with-exclude-criteria-for-every-nth-duplicate
Sheet: Sheet1

[NAME] | Year | Year to Use (Desired Result) | Project Code |  | # of duplicate before increment |  |  |  | DB Code | [NAME] |  | Unique Value
CLA1Dummy | 2022 |  | CLA |  | 2 |  |  |  | CLA1FOXB | CLA1Dummy
CLA1Dummy | 2022 |  | CLA |  |  |  |  |  | CLA1FOXB | CLA1Dummy |  | CLA2Dummy
CLA1Dummy | 2022 |  | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 |  | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 |  | CLA |  |  |  |  |  | CLASITE
CLA2Dummy | 2023 |  | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 |  | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 |  | CLA |  |  |  |  |  | CLAPHASE2 | CLA2Dummy
CLA3Dummy | 2024 |  | CLA
CLA4Dummy | 2025 |  | CLA
CLA4Dummy | 2025 |  | CLA
CLA4Dummy | 2025 |  | CLA
Spreadsheet: james_steffes__12850__CA rate exposure final 8-28 rev
Sheet: Legacy

LEGACY CUSTOMERS (DA as of 9/01/01 - but had switched back and forth)
PG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost |  |  |  |  |  | Weighted Avg. Total
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Avg | Probability |  |  |  | Avg | Probability |  |  |  | Avg
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
Edison | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
SDG&E | Utility Undercollection |  |  |  |  | Bonds |  |  |  |  | Above Market Contract Cost
 | Scenario | A | B | C |  | Scenario | A | B | C |  | Scenario | A | B | C
 | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted | % Collected |  |  |  | Weighted
 | Probability |  |  |  | Average | Probability |  |  |  | Average | Probability |  |  |  | Average
 | Factor | 1 |  | 0 |  | Factor | 1 |  | 0 |  | Factor | 1 |  | 0
Amortization (years)
5
7
10
12
15
Spreadsheet: 687920d1595490786-if-vlookup-combination-sample
Sheet: Sheet2

user name | Pending Acceptance of Invitation (Date)
Rajveer Dillon
Dillon Mohamed | 2020-08-03 00:00:00
[NAME] | 2020-08-13 00:00:00
Raife Galindo
[NAME]
Joann Preston
[NAME] | 2020-08-24 00:00:00
[NAME] | 2020-09-11 00:00:00
[NAME] | 2020-10-06 00:00:00
Poppy-Mae Hamer
Paris Rosa | 2020-10-21 00:00:00
[NAME] | 2020-10-23 00:00:00
[NAME] | 2020-11-18 00:00:00
Ksawery Villarreal
Anabella Nolan | 2020-12-01 00:00:00
[NAME] | 2020-12-02 00:00:00
[NAME] | 2020-12-22 00:00:00
 | List dates only if invitation is not yet accepted accepted